Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formaula used to abstract portion of a cell to another cell | Excel Worksheet Functions | |||
Help to write a formaula | Excel Worksheet Functions | |||
including two ranges of cells in an IF formaula | Excel Worksheet Functions | |||
insert rotating formaula | Excel Discussion (Misc queries) | |||
Formaula to multiply and add | Excel Worksheet Functions |