If statement formula help!

[excelprk92]

Hello, per attached image, I have 4 columns below. I need to devise an IF statement based on three conditions also below. Table sample also attached. thank you.

Column A - STATE (SOURCE 1)
Column B - STATE (SOURCE 2)
Column C - MATCH (A simple IF STATEMENT to see if cells in columns A & B match)
Column D - STATE_FINAL (final return value based on conditions below)

Condition 1 (true match per column C): Return value from Column B cell if value in cells in column A &B match
Condition 2 (false match per column C) : Return value from Column B cell if value in column A cell is 0
Condition 3 (false match per column C) : Return value from Column A cell if value in column B cell is 0

Excel_IFSTATEMENTHELP.png

[Pete_UK]

Try this in D2 (untested, as you did not supply a sample Excel workbook):

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

Copy down as required. I have assumed that you want blank to be returned if both A and B are zero. I also assume that you forgot to change the A2 and B2 references in your comments for rows 3 and 4.

Hope this helps.

Pete

[excelprk92]

Thank you so much for quick reply. To clarify, I would like non-zero values returned if the other neighboring cell is 0. Also you are correct on last statement. Please see revised conditions required. Can you offer a solution around this revision?

-return value from cell b2 if A2 & B2 match
-return value from cell b3 if A3 is 0
-return value from cell A4 if B4 is 0

[Pete_UK]

Did you try my proposed solution? It should give you what you have stated in your revised conditions.

Pete

[excelprk92]

Yes it returns 0 when formula is applied for a scenario seen in row 3 but would like 'NEw York' value returned

[popipipo]

Or use this formula

Please Login or Register  to view this content.

[excelprk92]

sorry that is not working either...

[popipipo]

Then take a look at this both formulas work

[excelprk92]

YES it worked!!! Thank you all so much for this!