easy problem that is killing me!

[mase062006]

I am writing a triple IF statement that reads

=IF(A1="X","SG3",IF(B1="X","SG2",IF(C1="X","SG1","")))

the formula works for putting the SG3 where i want it to go, but i am getting an error in the other 2 cells. Any ideas as to why the cells that are not true are not showing up as blank?

 

[oldbrewer]

if none are equal to X you will get an error

end it ),"red"),"blue")

 

[oldbrewer]

ignore my last post please

 

[Fluff]

What do you mean by

i am getting an error in the other 2 cells

A formula can only affect the cell it's located in.

 

[oldbrewer]

It works fine for me

 

[Aladin Akyurek]

=iferror(“SG”&lookup(9.99999999999999e+307,1/(a1:c1=“x”),{3;2;1}),””)

 

[oldbrewer]

FLUFF - HE IS PUTTING ALL THE POSSIBLES INTO THE CELL CONTAINING HIS FORMULA - i THINK

 

[mase062006]

Thanks all. Got it figured out. There was an extra space i didnt see.