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!
Peo Sjoblom - 29 May 2008 16:29 GMT
=MAX(A1-48,0)
where A1 is the cell

Signature
Regards,
Peo Sjoblom
>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!