| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting IF function | Excel Worksheet Functions | |||
| Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
| IF Function Nesting Problem | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
| Nesting A Function | Excel Worksheet Functions | |||
Linear Mode
