Formula Assistance Required

B

bruce2444

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

David Billigmeier

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

bruce2444

Thank you for your assistance

David Billigmeier said:
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")
Click to expand...
 
Top