View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default What's wrong with my formaula

Remove a comma at the

"Be18" wrote:

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