I hope someone can help, I've been searching the internet for 3 days and I have 2 problems. Here's what I'm needing to do:
1. In B5 I enter a number, in C5 (the Indicator) should show "LOW, "BORDERLINE LOW", "BORDERLINE HIGH", "HIGH" with the number entered. The formula that I have for this and works fine is: =IF(B5>100,"HIGH",IF(B5=100,"BORDERLINE HIGH",IF(B5=85,"BORDERLINE LOW",IF(B5<85,"LOW",))))
The problem comes in when there is no value to enter in B5. I'd like for C5 to return a blank cell if there is no value entered in B5.
2. In B13 I enter a number. Depending on whether G2 is an "M" or an "F" will determine which numbers need to be in C13, for example if G2 is an "F" the formula needs to look like =IF(B13>14.5,"HIGH",IF(B13=14.5,"BORDERLINE HIGH",IF(B13=13.5,"BORDERLINE LOW",IF(B13<13.5,"LOW",)))). And if G2 is an "M" then the formula needs to look like =IF(B13>15,"HIGH",IF(B13=15,"BORDERLINE HIGH",IF(B13=14,"BORDERLINE LOW",IF(B13<14,"LOW",)))). So C13 ( the Indicator) should return the appropriate value based on which set of parameters to use.
I've tried using the AND function but never seem to get it right. For this one I also need a blank cell returned in C13 if B13 has no number entered.
Thanks so much!
Bookmarks