Thread: Having trouble nesting function.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill R Bill R is offline
external usenet poster
  
Posts: 22
Default Having trouble nesting function.
If the sum of (F4*H4) = a negative number I want it to return a zero but I
can't seem to come up with a workable formula. Sugestions?


=IF(ISBLANK(G4),"",SUM(F4*H4))

Reply With QuoteReply With Quote