i have two if's and different else's for each ifi need to do this in one equation...is it possible

i need to do this in one equation...is it possible

Yes, it's called a Nested IF statement.=IF(A1=1,"A",IF(A1=2,"B",""))MIKEhttp://www.skeptic.com/

=IF(A1=1,"A",IF(A1=2,"B",""))

MIKE

http://www.skeptic.com/

Thank you! It works