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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create formula
try by defining
copy the formula =IF($L$6=4502,4402,IF($L$10=4502,4410,IF($L$14=450 2,4407,IF($L $18=4502,4403,IF($L$24=4502,4411,IF($L$28=4502,441 3,IF($L $32=4502,4400,IF($L$34=4502,4408,"")))))))) go to insert | names | define | names in workbook: abc | refers to : put above fomrula | ok | now any cell put =IF(abc,abc,IF($L$38=4502,4417,"")) On Nov 17, 12:15*pm, Ben wrote: 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,44 13,IF(L32=4502,4400,IF(L34=4502,4408,IF(L38=4502,4 4*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 |
Reply |
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) |