logical functions

[Guest]

can anybody help to solve it out...
if D4 is not a blank cell, then G3+E4-F4. if it is blank then look for G2 is
not a blank cell, then G2+E3-F3

Thanks,

 

[Ragdyer]

Try this:

=IF(NOT(ISBLANK(D4)),G3+E4+F4,IF(NOT(ISBLANK(G2)),G2+E3+F3,"What To Do?"))

 

[Guest]

=IF(D4<>"",G3+E3-F3,IF(G2<>"",G2+E3-F3,"else...."))

 

[Bernd]

Hello,

=IF(D4="",IF(G2="",1E308,G2+E3-F3),G3+E4-F4)

Substitute 1E308 by any value you need in this case.

Regards,
Bernd