Excel Help Please

[S 8 GRN]

Hi All,

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

Cell A1
Cell A2
Cell A3

A1 would be the result of a check of A2 - if there was no information in A2 then I want it to show A3

i.e

A2 = 3%
A3 = 6%

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

Hopefully that makes sense...

Thanks in advance all.

Edited by S 8 GRN on Thursday 18th February 18:42

[davefowler1987]

There you go
=IF(A2=0,A3,A2)

Edited by davefowler1987 on Thursday 18th February 18:43

[FlossyThePig]

=IF(A2="",A3,A2)

[S 8 GRN]

davefowler1987 said:

Will a2 be blank or will it be zero?
If you format the column to numbers then this should work
=IF(A2=0,A3,A2)
plave that in A1

You're a genius!

Thank you so much. Saved me hours of Google searching.

[S 8 GRN]

FlossyThePig said:

=IF(A2="",A3,A2)

You are ALSO a genius!