IF statement - Help!
I have three columns of data, column A, B & C.
I want to write an IF statement that looks at column A, and if it either retruns the contents of column B or column C depending on the match. eg. Column A Car Column B Non public transport Column C Public transport If column A = "Car" then return "Non public transport" else return "Public transport" |
In Cell D1 enter =IF(A1="Car",B1,C1)
Copy down as required. Regards Rowan "James" wrote: I have three columns of data, column A, B & C. I want to write an IF statement that looks at column A, and if it either retruns the contents of column B or column C depending on the match. eg. Column A Car Column B Non public transport Column C Public transport If column A = "Car" then return "Non public transport" else return "Public transport" |
Hi James
is this what you're after =IF(A1="Car",B1,C1) Cheers JulieD -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "James" wrote in message ... I have three columns of data, column A, B & C. I want to write an IF statement that looks at column A, and if it either retruns the contents of column B or column C depending on the match. eg. Column A Car Column B Non public transport Column C Public transport If column A = "Car" then return "Non public transport" else return "Public transport" |
Many thanks (again) JulieD and Rowan.
-----Original Message----- I have three columns of data, column A, B & C. I want to write an IF statement that looks at column A, and if it either retruns the contents of column B or column C depending on the match. eg. Column A Car Column B Non public transport Column C Public transport If column A = "Car" then return "Non public transport" else return "Public transport" . |
you're welcome ...
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "James" wrote in message ... Many thanks (again) JulieD and Rowan. -----Original Message----- I have three columns of data, column A, B & C. I want to write an IF statement that looks at column A, and if it either retruns the contents of column B or column C depending on the match. eg. Column A Car Column B Non public transport Column C Public transport If column A = "Car" then return "Non public transport" else return "Public transport" . |
All times are GMT +1. The time now is 11:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com