Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default What's wrong with my formaula

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 492
Default What's wrong with my formaula

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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formaula used to abstract portion of a cell to another cell CC Excel Worksheet Functions 4 October 11th 06 06:49 PM
Help to write a formaula Dinesh Excel Worksheet Functions 1 September 9th 06 06:27 AM
including two ranges of cells in an IF formaula Mark Excel Worksheet Functions 9 May 25th 06 03:49 PM
insert rotating formaula Rich Mcc Excel Discussion (Misc queries) 2 March 14th 06 02:19 PM
Formaula to multiply and add Frank Malone Excel Worksheet Functions 5 February 5th 06 10:52 AM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"