formula returning false

[sdts]

hi guys
i have a problem with a formula i am using
[CODE]=IF('working sheet'!D22<>"",'working sheet'!D22&IF('working sheet'!D24<>""," or "&'working sheet'!D24,""))[/CODE

what should happen is this

if there is a number in d22 and d24 the formula works fine
if there is no number in d22 then the formula doesnt work and returns the answer false

can anyone helps please

[barrboy89]

=IF(AND(D22<>"",D24<>""),"TRUE","FALSE")

Would that not work? Where "TRUE" could be replaced by whatever formula you wanted?

[Marcol]

Mabe this

Please Login or Register  to view this content.

Hope this helps

[Mike1001]

Hi sdts,

this is what your formula should look like:

Please Login or Register  to view this content.

There are four possible situations:
- both cells have values,
- no cell has values
- D22 has a value
- D24 has a value
and your formula has not considered all of these possible situations.

HTH
Mike

[sdts]

thanks guys for your replies

mike great result
works perfectly

thank you all

[Mike1001]

You're welcome!