try
>IF(F3*1.14-H3-K3=>0,0, Error)
IF((F3*1.14)-H3-K3=>0,0, "Error")
--
Don Guillett
SalesAid Software
donaldb@281.com
"bruce2444" <bruce2444@discussions.microsoft.com> wrote in message
news:9300BE28-AAF3-4EE6-8830-DC15A95F0BB9@microsoft.com...
> I'm trying to create a formula that if (f3)*1.14 minus (h3) minus (k3) is
> greater than or equal to zero, response would be "0" but if the response
is
> less than zero, response would be "Error" or some other message as a
visual
> marking that (f3)*1.14 minus (h3) minus (k3) is less than zero
>
> I tried this but get error message
>
> =IF(F3*1.14-H3-K3=>0,0, Error)
>