Excel Help Again! =IF Statements

[S 8 GRN]

After some amazing help yesterday I'm reaching out again!

So this time I want to check more than 1 cell - 2 to be precise.

I'm looking for a formula to solve the following problem:-

Cell A1
Cell A2
Cell A3
Cell A4

A1 would be the result of a check of A2 and A3 - if there was no information in A2 then I want it to show A3 and then finally if neither A2 nor A3 had any content it would show A4

i.e

A2 = 3%
A3 = 6%
A4 = 8%

A1 would show 3% however if A2 were blank then it would report 6% and if A2 and A3 were blank it would show A4

Hopefully that makes sense...

Thanks in advance all.

[TonyHetherington]

Nested IF statements.

You obviously understand IF statements, so what you now need to do is have the result of your IF statement as ANOTHER IF statement, and the results of that as ANOTHER if statement (i.e. nested).

3 or 4 nested is not too much of a problem, and depending where you click the formula in the formula bar Excel will helpfully show you that specific IF statement rather than the whole thing.

[Dupont666]

read this and I think it shows the code too....

http://www.techonthenet.com/excel/formulas/if_nest...

[anonymous-user]

I assume that if all cells are blank then you still want to show A2

=if(and(A2="",A3=""),A4,if(A2="",A3,A2))

Edited by anonymous-user on Friday 19th February 09:49

[S 8 GRN]

OneDs said:

I assume that if all cells are blank then you still want to show A2

=if(and(A2="",A3=""),A4,if(A2="",A3,A2))

Edited by OneDs on Friday 19th February 09:49

Absolutely perfect!

Thank you very much for your help.

In fact thanks everyone.