# [HELP] How to leave cells blank if another column is blank in a formula with multiple ifs.

1. ## [HELP] How to leave cells blank if another column is blank in a formula with multiple ifs.

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!  Register To Reply

2. ## Re: [HELP] How to leave cells blank if another column is blank in a formula with multiple

=if(f2="","",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)))))))))  Register To Reply

3. ## Re: [HELP] How to leave cells blank if another column is blank in a formula with multiple

That worked. Thanks a lot!!  Register To Reply

4. ## Re: [HELP] How to leave cells blank if another column is blank in a formula with multiple .................................  Register To Reply

5. ## Re: [HELP] How to leave cells blank if another column is blank in a formula with multiple

Shorter formula instead of multiple IF statements..

=IF(F2="","",LOOKUP(F2,{0,31,40,50,60,70,80,90},{0,8,25,41,58,75,91,100}))  Register To Reply