Issue with Nested IF statement for reading %s that are both positive and negative

I am trying write a nested IF statement that based on reading the value of % in column BR, will return a statement based on the value bucket it falls into: Greater than 5% Between 2.51% and 5% Bet...

BI & Data Analytics

Need Help

SergeiBaklan

Jul 26, 2018

=IF(BR5>=5%,"Greater than 5%",
   IF(AND(BR5>=2.5%,BR5<5%),"Between 2.5% and 5%",
   IF(AND(BR5>0%,BR5<2.5%),"Between 0% and 2.5%",
   IF(BR5=0%,"No Assignment",
   IF(AND(BR5<0%,BR5>-2%),"Between 0% and -2%",
   IF(AND(BR5<=-2%,BR5>=-5%),"Between -2% and -5%",
   IF(AND(BR5<-5.01%),"")
))))))

SergeiBaklan

Diamond Contributor

Jul 26, 2018

=IF(BR5>=5%,"Greater than 5%",
   IF(AND(BR5>=2.5%,BR5<5%),"Between 2.5% and 5%",
   IF(AND(BR5>0%,BR5<2.5%),"Between 0% and 2.5%",
   IF(BR5=0%,"No Assignment",
   IF(AND(BR5<0%,BR5>-2%),"Between 0% and -2%",
   IF(AND(BR5<=-2%,BR5>=-5%),"Between -2% and -5%",
   IF(AND(BR5<-5.01%),"")
))))))

laurenhruza

Copper Contributor

Jul 26, 2018

Thank you SO MUCH! This worked perfectly!

SergeiBaklan
Diamond Contributor
Jul 26, 2018
You are welcome

Forum Discussion

Issue with Nested IF statement for reading %s that are both positive and negative

Resources