KAY wrote:
What is wrong with the function?
=IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z")))))
Thank you for your help!
Karen

My guess is you would want A, B, C, D and E in quotes and 2, 4, 6, 8 and 10 not
in quotes.