=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