logical functions

A

Ali Akbar

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,
 
R

Ragdyer

Try this:

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

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
 
Top