IF Formula for Percent Range

[lossi44]

Hello, and thank you for your help in advance.

I have a list of percentages based on their original value, some may increase, some may decrease, or the value can stay the same as the original amount; or no change.

That said, I have the following criteria I can't seem to get right on an "IF" formula:
1) If the cell value (A11) is between 75% to 125%, then "No"
2) If the cell value (A11) is less than <75%, then "Yes"
3) If the cell value (A11) is more than >125%, then "Yes"

=IF(A11=75%-125%,"No",IF(AND(K11>126%,K11<74%),"Yes","Yes"))

 

[Caribeiro77]

That said, I have the following criteria I can't seem to get right on an "IF" formula:
1) If the cell value (A11) is between 75% to 125%, then "No"
2) If the cell value (A11) is less than <75%, then "Yes"
3) If the cell value (A11) is more than >125%, then "Yes"

=IF(A11=75%-125%,"No",IF(AND(K11>126%,K11<74%),"Yes","Yes"))

Are the red K really K or A?
I ask you this cause in your criterias you didn't mention column K

 

[lossi44]

Caludio, both, i've got a list of 20 and used copy from 'K' and wrote 'A' in the thread, my bad. Thanks, Carlos

 

[dreid1011]

Two options:

Assuming there are no other values you need to check for, then this should provide the desired results:
=IF(AND(A11>=0.75,A11<=1.25),"No","Yes")

Or

=LOOKUP(A11,{0,0.75,1.25},{"Yes","No","Yes"})

Also, you said "between 75% and 125%" but then in your formula you show >126% and <74%. Do you mean to include values of 75% and 125% in the No result? If so, then these formulas should do.

 

[Caribeiro77]

...

 

[lossi44]

Two options:

Assuming there are no other values you need to check for, then this should provide the desired results:
=IF(AND(A11>=0.75,A11<=1.25),"No","Yes")

Or

=LOOKUP(A11,{0,0.75,1.25},{"Yes","No","Yes"})

Also, you said "between 75% and 125%" but then in your formula you show >126% and <74%. Do you mean to include values of 75% and 125% in the No result? If so, then these formulas should do.

SUCCESS!!!! Thank you very much, I appreciate it! lossi44

 

[dreid1011]

SUCCESS!!!! Thank you very much, I appreciate it! lossi44

You're welcome.