# [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!

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)))))))))

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

That worked. Thanks a lot!!

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

.................................

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}))

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1