IF function
You need to put quotes around the letters, like this:
=IF(H55="A","2",IF(H55="B","4",IF(H55="C","6",IF(H 55="D","8",IF(H55="E","10","Z")))))
However, you might NOT need the quotes around the numbers, as they
will become text values.
Hope this helps.
Pete
On Aug 13, 2:23*pm, 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
|