logical functions
 

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,

logical functions
 

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ali Akbar" <Ali wrote in message
...
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,

logical functions
 

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


"Ali Akbar" wrote:

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,

logical functions
 

Hello,

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

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

Regards,
Bernd