Thank you for your assistance

"David Billigmeier" wrote:

> You get an error because just typing Error confuses Excel, instead try
> putting Error in quotes, like:
>
> =IF(F3*1.14-H3-K3=>0,0,"Error")
>
> --
> Regards,
> Dave
> <!--
>
>
> "bruce2444" wrote:
>
> > 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)
> >