Another IF THEN question

  • Thread starter Thread starter Sylvain
  • Start date Start date
S

Sylvain

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 G13=0 and I13=1 then write "A1-7", IF G13=0 and I13=2
then write "A1-8", IF G13=0 and I13=2 then write "B1-7",
IF G13=0 and I13=3 then write "B1-7" etc......

how do I create a similar formulas i tried but doesn't
work

=IF(G13=0,IF(I13=1,"A1-7",IF(G13=0,IF(I13=2,"A1-8",IF
(G13=0,IF(I13=3,"B1-7",IF(G13=0,IF(I13=4,"B1-8",IF(G13=1,IF
(I13=1,"A1-9",IF(G13=1,IF(I13=2,"A1-10",IF(G13=1,IF
(I13=3,"B1-9",IF(G13=1,IF(I13=4,"B1-10",IF(G13=2,IF
(I13=1,"A1-11",IF(G13=2,IF(I13=2,"A1-12",IF(G13=2,IF
(I13=3,"B1-11",IF(G13=2,IF(I13=4,"B1-12",IF(G13=3,IF
(I13=1,"A1-13",IF(G13=3,IF(I13=2,"A1-14",IF(G13=3,IF
(I13=3,"B1-13",IF(G13=3,IF(I13=4,"B1-14",IF(G13=4,IF
(I13=1,"A1-16",IF(G13=4,IF(I13=2,"A1-17",IF(G13=4,IF
(I13=3,"B1-16",IF(G13=4,IF(I13=4,"B1-17","blank
cell"))))))))))))))))))))))))))))))))))))))))

Thanks
-----Original Message-----
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!


.
Click to expand...
..
 
Hi Sylvain,
You can next functions only to a level of 7. I think you would be well
served by reading Help under VLOOKUP. We can give specific advice when you
are ready.
Bernard
 
Sylvain,

How about trying this?

=CHOOSE(I13,"A1-","A1-","B1-","B1-")&IF(ISODD(I13),1,2)+(G13+1)*2+4

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Perhaps something like:

=IF(G13>4, "", CHAR(65+INT(I13/3))&"1-" & 7+G13*2+ISEVEN(I13))
 
Back
Top