[SOLVED] 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

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

--
Don Guillett
SalesAid Software
[email protected]
"RGT" <[email protected]> wrote in message
news:[email protected]...
> 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

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

=MAX(F14-F47,0)

Vaya con Dios,
Chuck, CABGx3


"RGT" <[email protected]> wrote in message
news:[email protected]...
> 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