Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and logical functions | Excel Worksheet Functions | |||
Logical functions to calculate points | Excel Worksheet Functions | |||
Create a function to return text if two logical functions are true | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions |