# Thread: Quick question,, Multiple IF statements: want to add a "" if the result if FALSE/the reference cell I2 is blank Thanks: 0 Likes: 0

1. ## Quick question,, Multiple IF statements: want to add a "" if the result if FALSE/the reference cell I2 is blank

=IF(I2="Weld Rod","A",IF(I2="Flame Spray Poweders","B",IF(I2="Special Applicate Coatings","C",IF(I2="Liquid Pen Materials","D",IF(I2="Assorted Glues","E",IF(I2="Powders Blasting MTRL","F",IF(I2="Materials","G")))))))

If I2 is blank the result is: FALSE. How do I get it to display a blank cell if False?

I tried a ,"" after the first return result for each statement and tried a IFERROR for the entire formula but both are a no go.

Thank you

Carla

2. ## Re: Quick question,, Multiple IF statements: want to add a "" if the result if FALSE/the reference cell I2 is blank

These kind of formulas are best written as lookup functions:

IJKLM
2Flame Spray PowedersBWeld RodA
3Flame Spray PowedersB
4Special Applicate CoatingsC
5Liquid Pen MaterialsD
6Assorted GluesE
7Powders Blasting MTRLF
8MaterialsG

Sheet7

Worksheet Formulas
CellFormula
J2=IFERROR(VLOOKUP(I2,\$L\$2:\$M\$8,2,0),"")

3. ## Re: Quick question,, Multiple IF statements: want to add a "" if the result if FALSE/the reference cell I2 is blank

I always think of the most complicated way first lol. This is much nicer, thank you very much!!

4. ## Re: Quick question,, Multiple IF statements: want to add a "" if the result if FALSE/the reference cell I2 is blank

Try IF(I2="Materials","G","") instead of IF(I2="Materials","G")

What do you want to happen if I2 contains some other text? At the moment that would also return a FALSE or with the changed formula a null.

6. ## Re: Quick question,, Multiple IF statements: want to add a "" if the result if FALSE/the reference cell I2 is blank

To respond to Toadstool: I2 is a drop down list so they have to choose one of the provided selections. Thank you everybody

## User Tag List

#### Posting Permissions

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