IF statement - Help!

  • Thread starter Thread starter James
  • Start date Start date
J

James

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
 
Hi James

is this what you're after
=IF(A1="Car",B1,C1)

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Having Blank Cells, etc. ? 1
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
SUM - IF - AND 7
Hard-Coding Vs Coding for Dynamic Header 0
IF Formula not working 12
#NA error when doing a look up 1
IF/OR Statement 4
Returning Value of Next Non-Blank Cell in Column 2

Back
Top