ExcelBanter - Please help

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

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

- - Please help (https://www.excelbanter.com/excel-worksheet-functions/189267-please-help.html)

Dawnavyn

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!

Peo Sjoblom

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!

All times are GMT +1. The time now is 05:52 AM.