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

[willow1985]

=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

 

[Eric W]

These kind of formulas are best written as lookup functions:

Book1
	I	J	K	L	M
2	Flame Spray Poweders	B		Weld Rod	A
3				Flame Spray Poweders	B
4				Special Applicate Coatings	C
5				Liquid Pen Materials	D
6				Assorted Glues	E
7				Powders Blasting MTRL	F
8				Materials	G
Sheet7

Cell Formulas
Range	Formula
J2	=IFERROR(VLOOKUP(I2,$L$2:$M$8,2,0),"")

 

[willow1985]

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

 

[Toadstool]

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.

 

[Eric W]

Glad to help!

 

[willow1985]

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