| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulae containing more than 7 arguments?
I want to input a formula to a cell that contains 10 arguments - I realise I
cannot use the IF function for more than 7 arguments. So what formula would I use to find: If A1 is blank, return a "1". If A1 contains a "1", return a "2", if it contains a "2", return a "3" etc up to and including a "9"? (i.e. 10 arguments in all. Can it be done? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the results of formulae between different spreadsheets. | Excel Worksheet Functions | |||
| Change to formulae | Excel Worksheet Functions | |||
| Dynamic formulae - similar to lotus 123 for excel | Excel Discussion (Misc queries) | |||
| XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) | |||
| vlookup change column index position - without changing formulae | Excel Worksheet Functions | |||
Threaded Mode
