Trying to find a formula that changes depending on a (A2) cell's percentage. I have tried for hours and still no luck. I have Excel version 14.3.8 from 2011 version on a MAC. The formula for a three part version of this is =IF(A2<33%, "LOW",IF(A2<67%,"MED","HIGH")). Here are the rules and conditions I would like:
1) When A2 < 33% - "LOW"
2) When 33% =< A2 =< 49% - "LOW-MED"
3) When 49% < A2 < 67% - "HIGH-MED"
4) When A2 >= 67% - "HIGH"
Please let me know the formula to use and how to set the conditions so that they can appear on multiple sheets.
Thanks,
Alex
Bookmarks