| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell calculation check if result is negative and zero out if not l
Formula in cell =(B5-A5) I want to check if result is negative and if so
replace result with 0 So this cell will either be a positive number or zero. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell calculation check if result is negative and zero out if not l
=MAX(0,(B5-A5))
Vaya con Dios, Chuck, CABGx3 "Rich" wrote: Formula in cell =(B5-A5) I want to check if result is negative and if so replace result with 0 So this cell will either be a positive number or zero. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell calculation check if result is negative and zero out if not l
=MAX(B5-A5,0)
-- HTH RP "Rich" wrote in message ... Formula in cell =(B5-A5) I want to check if result is negative and if so replace result with 0 So this cell will either be a positive number or zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
