View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JustBreathe JustBreathe is offline
external usenet poster
 
Posts: 22
Default Having trouble nesting function.

what about =IF((F4*H4)<=0,0,(F4*H4))

"Bill R" wrote:

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))