You have a reply in excel.misc
Alan.
"Be18" wrote in message
...
I currently have the following formula

=IF(D12="SWR","Liz
Bed",IF(D12="TCH","lex",IF(D12="POS","Mav",IF(D12= "INT","Rich",
IF(D12="FOU","Ton",)))))

but when i click out of the box, it does not work out the value, the text
just remains - please can you tell me what is wrong with my formula and
how
i can get it to calculate?

Thank you