Formula Assistance Required

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)

=If((f3*1.14-(h3+k3))>=0,0,"Error")

************
Anne Troy
www.OfficeArticles.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)
>

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)
>

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)
>

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)
> >