Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create formula
At present I am using:-
=IF(L6=4502,4402,IF(L10=4502,4410,IF(L14=4502,4407 ,IF(L18=4502,4403,IF(L24=4502,4411,IF(L28=4502,441 3,IF(L32=4502,4400,IF(L34=4502,4408,IF(L38=4502,44 17,""))))))))). I'm using Excel 2003 and it won't allow 9 nested functions. Is there another way around it,to get the same result -- Reynella |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
How do I create a formula | Excel Worksheet Functions | |||
how to create this formula please | Excel Discussion (Misc queries) | |||
Create Formula | Excel Discussion (Misc queries) |