ExcelBanter - Having trouble nesting function.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Having trouble nesting function. (https://www.excelbanter.com/excel-worksheet-functions/145135-having-trouble-nesting-function.html)

Bill R

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

Toppers

Having trouble nesting function.

=IF(ISBLANK(G4),"",MAX(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))

JustBreathe

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

All times are GMT +1. The time now is 04:19 AM.