Solved problem with nested if/and statements

October 13, 2011 at 10:46:02
Specs: Windows XP
Hello

I am trying to set up nested if/and statement based on criteria from 3 columns

for example: if g=n then always 0, if g=y and h=y and i=y, then C, if g=y and h=y and i=n, then A, if g=y and h=n and i=n, then B, if g=y and h=n and i=y, then D


See More: problem with nested if/and statements

Report •


#1
October 13, 2011 at 12:47:10
✔ Best Answer
=IF(G1="n", 0, IF(AND(H1="y", I1="y"), "C", IF(AND(H1="y", I1="n"), "A", etc...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 13, 2011 at 15:20:39
and here I was making it waaaay harder than it needed to be, eliminate the g column right away and just work with the two - thanks!

Report •

Related Solutions


Ask Question