Formula help

[MissK2018]

Hi There,

I'm trying to do the following:
if K7 is greater than or equal to 10 but less than 11 enter "10%"
if K7 if greater than or equal to 6 but less than 10 enter "7%"
If K7 is greater than or equal to 3 but less than 6, enter "5%"
If K7 is less than or equal to 2 enter "2.5%"

=IF(AND(K7>=10,K7<11),"10%"),IF(AND(K7>=6,K7<10),"7%",IF(AND(K7>=3,K7<6),B31,"5%", IF(K7<=2,"2.5%"))))

I've got something wrong here but I can't figure it out ..

Any help would be greatly appreciated!

 

[Hurkk]

Hello,

Try this formula:
=IF(AND(K7>=10,K7<11),"10%",IF(AND(K7>=6,K7<10),"7%",IF(AND(K7>=3,K7<6),"5%", IF(K7<=2,"2.5%"))))

Hurkk

 

[MissK2018]

Thank you !!


I see what I did now. I looked so hard I couldn't see the two mistakes !!

Thank you!

 

[Joe4]

Note that if you plan to use the values it returns in calculations, you will want to make a minor change.
Remove the double-quotes from around the percentages, i.e.
change
"10%"
to
10%

Using double-quotes will return the value as text, and not numeric, so it probably won't work right if being used in calculations.