Create formula

[Ben]

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,4413,IF(L32=4502,4400,IF(L34=4502,4408,IF(L38=4502,4417,""))))))))).

I'm using Excel 2003 and it won't allow 9 nested functions. Is there another
way around it,to get the same result

 

[muddan madhu]

try by defining

copy the formula
=IF($L$6=4502,4402,IF($L$10=4502,4410,IF($L$14=4502,4407,IF($L
$18=4502,4403,IF($L$24=4502,4411,IF($L$28=4502,4413,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,""))