Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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" |
#2
![]() |
|||
|
|||
![]()
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" |
#3
![]() |
|||
|
|||
![]()
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" |
#4
![]() |
|||
|
|||
![]()
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" . |
#5
![]() |
|||
|
|||
![]()
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" . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |