Click here for important information about Computing.net.

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

=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.

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!

Ask Your Question

Weekly Poll

Do you think Intel's new hybrid chips will better compete with Apple/ARM?

Discuss in The Lounge

Poll History