So the current formula I have is =IF(F2>=90,100,IF(F2>79,91,IF(F2>69,75,IF(F2>59,58,IF(F2>49,41,IF(F2>39,25,IF(F2>30,8,IF(F2<=30,0)))))))). It works well except that when F2 is blank it gives me 100. What do I have to include in the formula to make it blank.
Thanks!
Bookmarks