Posted to microsoft.public.excel.worksheet.functions
|
|
IF function
You have it backwards.
"A"
2
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"KAY" wrote in message
...
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
|