| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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) |
|
#2
|
|||
|
|||
|
=If((f3*1.14-(h3+k3))=0,0,"Error")
************ Anne Troy www.OfficeArticles.com "bruce2444" wrote in message ... 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) |
|
#3
|
|||
|
|||
|
try
IF(F3*1.14-H3-K3=0,0, Error) IF((F3*1.14)-H3-K3=0,0, "Error") -- Don Guillett SalesAid Software "bruce2444" wrote in message ... 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) |
|
#4
|
|||
|
|||
|
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) |
|
#5
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Assistance | Excel Worksheet Functions | |||
| addition to my date formula...required | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Rate of return required formula | Excel Worksheet Functions | |||
Linear Mode
