Try:

=IF(OR(B18={136,160,816,817}),97,IF(OR(B18={138,68 48,8527}),1,IF(OR(B18={8954,1771,162,1771}),447,IF (B18=155,448,""))))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"George" wrote in message
...
I'm fairly comfortable working within Excel; however, I just know there
must
be a work-around for multiple nesting requirements that I probably simply
just do not know of.
Specifically, I am looking for either the correct argument/formula or
"trick" to be able to complete an entry such as the following:

=IF(B18=136,"97",IF(B18=816,"97",IF(B18=160,"97",I F(B18=817,"97",IF(B18=138,"1",IF(B18=6848,"1",IF(B 18=8527,"1",IF(B18=8954,"447",IF(B18=1773,"447",IF (B18=163,"447",IF(B18=1772,"447",IF(B18=155,"448", ""))))))))))))
I would appreciate any time you are able to spend with this request.
--
Thanks.
George*