I am very new to Excel (I've only used it a few times before this). I
have already figured out (mostly by accident) how to get my worksheet
to give me the following:

One cell is for input of the company Division numbers. When a number
is entered, the employee number and manager name of that Division
appear in other cells. If nothing is entered, I want it to remain
blank.

My current formula for six of the employee numbers and the "blank"
is:

=IF(K53=301,"11517",IF(K53=901,"11517",IF(K53=701, "40323",IF(K53=801,"40323",IF(K53=601,"99253",
IF(K53=401,"41723",IF(K53=""," ")))))))

Since I can only nest seven things, I can't get the seventh or eighth
manager into the formula and still keep the blank option. However,
currently three of the managers are each overseeing two or three
Divisions each, so I'd like to add an OR statement in there. I'd like
it to say that if K53 has either 301 or 901 to put employee 11517, if
K53 is 701 or 801 to put employee 40323, if K53 is 501 or 503 or 685
to put employee 49325, if K53 is 662 to put employee 05498, and keep
the rest of the IF statements as they are. Division 662 is a special
exceptions thing, though, so rarely used and can be left out if need
be.

I don't know how to set up the formula though. I tried doing just one
of the managers and thought I had it, but keep getting "FALSE" when I
test it. Can any more experienced person help me get a formula that
works (with or without the 662 guy).

Thanks.