ExcelBanter - Create formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Create formula (https://www.excelbanter.com/excel-discussion-misc-queries/210521-create-formula.html)

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

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