ExcelBanter - If Then help needed

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - If Then help needed (https://www.excelbanter.com/new-users-excel/18211-if-then-help-needed.html)

RGT

If Then help needed

I need a formula that basically works like this....

If the total (currently =F14-F47) is less than zero show zero, else
show the number.

any suggestions??

Russell

Don Guillett

=if(f14-f47<0,0,f14-f47)

--
Don Guillett
SalesAid Software

"RGT" wrote in message
...
I need a formula that basically works like this....

If the total (currently =F14-F47) is less than zero show zero, else
show the number.

any suggestions??

Russell

CLR

One way...........

=MAX(F14-F47,0)

Vaya con Dios,
Chuck, CABGx3

"RGT" wrote in message
...
I need a formula that basically works like this....

If the total (currently =F14-F47) is less than zero show zero, else
show the number.

any suggestions??

Russell

All times are GMT +1. The time now is 12:10 PM.