MULTIPLE NESTING WITHIN EXCEL
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*
|