If Then help needed

RGT · Mar 18, 2005

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 · Mar 18, 2005

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

CLR · Mar 18, 2005

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

=MAX(F14-F47,0)

Vaya con Dios,
Chuck, CABGx3

If Then help needed

RGT

Don Guillett

CLR