| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Array
Can anyone tell me how to put more than 9 if statements into a single formula ? I can get 9 om a row but not 9 for instance if i want to detect the numbers of days in a mont on a large spreadsheet I may enter =if(a1="Jan",31,if(a1="Feb",28,if(a1="Mar",31,0))) and so on, I can get it to work upto September with it working then it comes up with an error, PS sorry also posted this on Excel worksheet functions page by mistake Thank Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Threaded Mode
