My bad. Sorry.

I'm OK with doing it in a macro.

Input cell = A1 = 100

Possible Name Values:
B1 = 1
B2 = 2
B3 = 3
B4 = 4

If A1<=100, then define range name XYZ = B1
If A1 100 and <200, then define range XYZ = B2
If A1 200 and <300, then define range XYZ = B3
If A1 300, then define range XYZ = B4



"Don Guillett" wrote in message
...

A formula can only return a value. You would need a macro and more
explanation to us.
Your a1 a2 below don't seem to be consistent. Typo?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kent McPherson" wrote in message
...
I have a formula which references a cell which has been defined as a Name
under Insert/Name/Define... The formula works just fine. However I
want the named definition to be variable based on the input of another
cell. For example:

Input cell = A1 = 100

Possible Name Values:
B1 = 1
B2 = 2
B3 = 3
B4 = 4

If A1<=100, then define range name XYZ = B1
If A2 100 and <200, then define range XYZ = B2
If A2 200 and <300, then define range XYZ = B3
If A2 300 and <400, then define range XYZ = B4

Ideas?