fill cell with info from other cells using IF statement

[acp]

Hi, all. I've created what I thought would be a simple IF statement based on a couple others I found on this site but I'm having trouble getting it to work properly past the second or third "IF". My goal is to fill in one cell (in column D) based on the info in three other cells in the same row (columns A, B and C).

If A2 is not equal to 0, insert the data from A2.
If A2 IS equal to 0, insert the data from B2.
If B2 is equal to 0, insert the data from C2.
If C2 is equal to 0, insert the word "none".

If it's easier, I can do it this way instead (I'd prefer to use the zeroes, though):

If A2 is not empty, insert the data from A2.
If A2 IS empty, insert the data from B2.
If B2 is empty, insert the data from C2.
If C2 is empty, insert the word "none".

These are the two formulas I've been working with.

=IF(A2<>0,A2,IF(A2=0,B2,IF(B2=0,C2,IF(C2=0,"none"))))

=IF(A2<>"",A2,IF(A2="",B2,IF(B2="",C2,IF(C2="","none"))))

The first two IFs work, but when it gets to C, it stops working and just shows a zero. Am I even close to getting the statements correct? Any help is appreciated.

Thanks,
Angie

[NBVC]

IF statements work from left to right, and the function stops as soon as a TRUE result occurs. So if the C part is not working, it might be because one or more of the previous conditions have already been met.

[dilipandey]

Hi Angie,

but when it gets to C, it stops working and just shows a zero.

How.. ? can you show a sample workbook? thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[acp]

My apologies to both of you for not thinking to include what actually wasn't working. I should have said that if A1 or B1 are not equal to 0, the correct data is being filled in. If B1 is equal to 0, it does not fill in data from C1. And if C1 is equal to 0, it does not fill in "none" (if that last one doesn't work it isn't the end of the world -- I can live with just the zero).

I'm not sure how to insert a spreadsheet like I've seen others do, so I'm attaching a copy, if that's okay. test_file.xlsx

[NBVC]

The first part of your formula: =IF(A2<>0,A2,IF(A2=0,B2, forces a stop here... because A2 is always going to be not equal to it will be equal to 0... so you will always get either A2 or B2 value as a result.

Try:

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

[acp]

That worked perfectly. Thanks so much for helping me!