| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel 2003 (multiple IF statements)
Hi there,
I need help with a multiple IF formula. I have used a drop down list in 1 cell that has about 20 items in it. I have used an "IF <cell = "test", type formula but it seems to fail after 8 IF's?? Why is this - as I need to return about 20 different responses from the worksheet. i.e. IF B2="strawberries","fruit" IF B2="pumpkin","vegetable" etc. How do I include all of this in one line? is it possible? Much Appreciated Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting more than 7 IF statements (Excel 2003) | Excel Worksheet Functions | |||
| Case Statements in Excel 2003 | Excel Discussion (Misc queries) | |||
| Is there an equation in Excel to use multiple if then statements? | Excel Discussion (Misc queries) | |||
| If statements (of course) {running excel 2003} | Excel Discussion (Misc queries) | |||
| How do I set up multiple if statements in Excel? | Excel Worksheet Functions | |||
Threaded Mode
