multiple column if statement

[gill123]

I am very new at doing formula in excel. How do I do a if statement that looks at multiple columns.


Example:
A B C
Row1 1982
Row2 1974
Row 3 1982
Row 4 1974

I need a if statement first to read Column A , if there is year in column A then give me the year. If there is not year in column A then look at column B, if there is year in B then give that year, If no year in column B then look at C and then give me the year in C.

Thank you

[JohnTopley]

Try ...

Assumes only ONE date in any row in A to C

=INDEX(A1:C1,,MAX(IF(--(A1:C1<>0),COLUMN(A1:C1),0)),1)

Enter with Ctrl+Shift+Enter and copy down rows

[Pete_UK]

It is difficult to see what you have from your example, but if the columns are either empty or contain a year, and if there is only one column which is not empty in any one row, then you can do this:

=--(A1&B1&C1)

then copy down.

Hope this helps.

Pete

[gill123]

Pete_UK how do i display if there is blank cell. I keep getting #VALUE! for blank cells.

[ericbartha]

I just read the other comments and John's solution is a lot better and more robust. I was just tyring to keep it simple. Just make sure you hit Ctrl+Shift+Enter.

However, if there will NEVER be any value in the other cells, eg they really are always blank, and you a realllllly trying to keep it simple for some reason, you really could just do a SUM of MAX function... SUM(A2:C2) for example....

[ericbartha]

What is the cell value of A2 if there is NO year? Is it blank or something else?

[gill123]

it is blank ericbartha

[ericbartha]

Try this...

=IF(SUM(A2,B2)=0,C2,IF(A2="",B2,A2))

[gill123]

Thank you every one for quick Reply!