Thread: logical functions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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,

Reply With QuoteReply With Quote