Hi,
I cannot determine what is wrong with the following formula?
I have three cells, D12, E12 and F12. I wish to enter one value of a range in D12 (AC, L, P, U, R) and one value of a range in E12 (MI, MO, S, MA, CA) to produce ,depending on the D12 and E12 values entered, a result from a range of values in F12 (L, M, H, C).
Any assistance would be appreciated!
=IF(AND(D12="AC", E12="MI", "M", IF(AND(D12="AC", E12="MO", "H", IF(AND(D12="AC", E12="S", "C", IF(AND(D12="AC", E12="MA", "C", IF(AND(D12="AC", E12="CA", "C", IF(AND(D12="L", E12="MI", "M", IF(AND(D12="L", E12="MO", "M", IF(AND(D12="L", E12="S", "M", IF(AND(D12="L", E12="MA", "M", IF(AND(D12="L", E12="CA", "M", IF(AND(D12="P", E12="MI", "M", IF(AND(D12="P", E12="MO", "M", IF(AND(D12="P", E12="S", "M", IF(AND(D12="P", E12="MA", "M", IF(AND(D12="P", E12="CA", "M", IF(AND(D12="U", E12="MI", "M", IF(AND(D12="U", E12="MO", "M", IF(AND(D12="U", E12="S", "M", IF(AND(D12="U", E12="MA", "M", IF(AND(D12="U", E12="CA", "M", IF(AND(D12="R", E12="MI", "M", IF(AND(D12="R", E12="MO", "M", IF(AND(D12="R", E12="S", "M", IF(AND(D12="R", E12="MA", "M", IF(AND(D12="R", E12="CA", "M", " " ))))))))))))))))))))))))))))))))))))))))))))))))))
Thanks.
Bookmarks