Fantastic thank you. This of course has flowed onto the last two formula's I
have on my spreadsheet.

Can I explain.

By using your last formula =if(or(O22="",P22=""),"",O22+P22) Q22 is now
blank,which looks great,however this has effected U22 and V22.

U22 has the formula T22-Q22 so it now shows 'value!' and V22 has a formula
of =U22/12 which now shows '#####'

I have tried this and it seems to have worked.

U22: =IF(OR(T22="",Q22=""),"",T22-Q22)
V22: =IF(OR(U22=""),"",U22/12)

Do you agree?





"joeu2004" wrote:

On Feb 13, 9:59 am, Scoober wrote:
i got a 'FALSE' message.
=if(or(O22="",P22=""),""=SUM(O22,P22))
Can you tell me where I went wrong?

Assuming that you cut-and-pasted the formula exactly as you entered
it, the problems a you are missing a comma, and you have an
extraneous "=". You should have written:

=if(or(O22="",P22=""),"",SUM(O22,P22))

However, if you are going to the trouble of testing O22 and P22, you
should no longer need SUM. So you could write:

=if(or(O22="",P22=""),"",O22+P22)