| 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 | |||
Linear Mode
