MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Nested If's (I think)


Posted by marco on January 04, 2001 9:37 PM

I have 2 cols each require either a Y or N to be input into either col. How do I output a given value for each combination of Y or N. for e.g.
col 1 col 2 col 3 (value required)
y n = 1
n n = 2
y y = 3
n y = 3

I have tried to used a nested If with AND and OR function but no go, am I on the right track,
Please help have spent about 3 days playing with this.

Many thanks

Marco


Posted by cpod on January 04, 2001 10:01 PM

Try this:

=IF(A1="y",IF(B1="y",3,1),IF(B1="y",3,2))