Formula Assistance Required

G

Guest

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

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula for inventory problem 2
Value of minutes not calculated 8
A More efficient way to have a function with multiple SUMIF functions. 2
NEST A IF WITHIN A IF 4
Mulitple "IF/OR" statments 3
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Can multiple criteria be used for IF formulas? 4
Total Working hours If 2

Top