Formula help

[BORUCH]

Hi all

i have been breaking my head to figure this out if someone can help me i would greatly appreciate it

the formula is as follows

=IF(data[Discount Percentge]=0,"no discount",IF(AND(data[Discount Percentge]>0,data[Discount Percentge]<=0.05),"discount 1 .00% to 5.00%",IF(AND(data[Discount Percentge]>=0.05000001,data[Discount Percentge]<=0.1),"discount 2 5.00% to 10.00%",IF(AND(data[Discount Percentge]>=0.10001,data[Discount Percentge]<=0.35),"Discount 3 10.00 % TO 35.00 %",IF(AND(data[Discount Percentge]>=0.35001,data[Discount Percentge]<=0.75),"Discount 4 35.00 % TO 75.00 %",IF(AND(data[Discount Percentge]>=0.75001,data[Discount Percentge]<=100),"DISCOUNT 5 75.00 % TO 100.00 %","NEGATIVE"))))))

my problem is if i have a discount percent of exactly 5.00% it shows negative the question is why

if someone can please help me

thanks

 

[Fluff]

I suspect it's not exactly 5%, how about
=IF(data[Discount Percentge]=0,"no discount",IF(data[Discount Percentge]<=0.05,"discount 1 .00% to 5.00%",IF(data[Discount Percentge]<=0.1,"discount 2 5.00% to 10.00%",IF(data[Discount Percentge]<=0.35,"Discount 3 10.00 % TO 35.00 %",IF(data[Discount Percentge]<=0.75,"Discount 4 35.00 % TO 75.00 %",IF(data[Discount Percentge]<=100,"DISCOUNT 5 75.00 % TO 100.00 %","NEGATIVE"))))))