View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd Bernd is offline
external usenet poster
 
Posts: 92
Default 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