R
ramk1h
I am attempting to nest 6 'IF' statements with no success, code a
follows:
=IF(C11="A",D11=5,IF(C11="B",D11=4,IF(C11="C",D11=3,IF(C11="D",D11=2,IF(C11="E",D11=1,IF(C11="F",D11=0,))))))
Any pointers as to my mistake would be greatly appreciated
follows:
=IF(C11="A",D11=5,IF(C11="B",D11=4,IF(C11="C",D11=3,IF(C11="D",D11=2,IF(C11="E",D11=1,IF(C11="F",D11=0,))))))
Any pointers as to my mistake would be greatly appreciated