| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help
I am needing to create a formula that will give me .......
If (cell number) is greater then 48 then what is the difference. If it is 48 or less then difference shouldn state 0. HELP Please! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help
=MAX(A1-48,0)
where A1 is the cell -- Regards, Peo Sjoblom "Dawnavyn" wrote in message ... I am needing to create a formula that will give me ....... If (cell number) is greater then 48 then what is the difference. If it is 48 or less then difference shouldn state 0. HELP Please! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
