another IF THEN question

  • Thread starter Thread starter keyt
  • Start date Start date
K

keyt

One option is to embed the if statements:

if(I3=0,"014A",(IF (I3=1,"050A, (if (I3=2, "118A", (IF
(I3=3, "159A", "blank cell")))))))

But, you've written your question wrong, because you said
that I3 = 1, 2, 3, or 4, and then below you said I3 =
0,1,2, or 3; so make sure you don't just opy what I've
done here!
 
Thank you this was helpful and you're right I've done a
mistake about number in the question,

I have another question.

If I want to verify 2 cells, like as follow:

IF G2=0 and I2=1 then write "A1-7", IF G2=0 and I2=1 then
write "A1-8", IF G2=0 and I2=2 then write "B1-7", IF G2=1
and I2=1 then write "A1-9" etc......

how do I create a similar formulas

Thanks
 
Back
Top