An IF formula with a variable?

[Prangendevraag]

Hi all,

I want to place a formula in cel C1 that containes the following:
If the value in A1 is lower than the value in B1-0,5 then return “High” (meaning the value in cel B1 is high)
If the value in A1 varies between the value in B1-0,5 and the value in B1+0,5 then return “OK” (meaning the value in cel B1 is OK)
If the value in A1 is higher than the value in B1+0,4 then “Low” (meaning the value in cel B1 is low)

The value in B1 can ofcourse vary.
So, if the value in B1 is 2, and the value in A1 is
-from 1,5 til 2,4, then C1 should return OK
-below 1,5, then C1 should return Low
-above 2,4, then C1 should return High

I came up with this

=IF(AND(A1<B1-0,5;”High”;IF(A1>B1+0,5;”Low”;IF(A1<=B1-0,5;A1>=B1+0,4;OK”))) 

….. but it doesn’t work… What should the formula be?

Thanks in advance for looking into this.
Greetings,
P
(I don't even know what the description of this topic / of this type of formula should be)

[Prangendevraag]

Sorry, there should be a ")" extra on the end I think. But it still doesn't work...

[Prangendevraag]

Again sorry, I also forgot an " before OK.

This is the formula again

=ALS(EN(A1<B1-0,5;"H";ALS(A1>B1+0,5;"L";ALS(A1<=B1-0,5;A1>=B1+0,4;"OK")))) 

And I get "#NAME?" in return.

[samba_ravi]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[samba_ravi]

=IF(A1<B1-0,5;”High”;IF(A1<B1+0,5;”OK”;"Low"))

[Prangendevraag]

Thank you, that's it!!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.