assigning cell value based on a number range

[dzedncnfused]

I was able to get this statement to work as expected

=IF(AND(A2>=1,A2<=99),$A$1,IF(AND(A2>=100,A2<=900),$A$53))

the problem is I have about 15 or 20 ranges I would like to use
1-99, 100-900, 901-1105, etc. ranges are variable.

I know I can only nest 7 If statements together. Even I could figure out how to do that there has to be a better way :-)

My VBA skills are barely above nil.

Not sure if I'm in the right portion of the forum. Let me know I can repost if necessary.

[ConneXionLost]

Consider using the LOOKUP function, or building a lookup table that lists your desired values.

If you would like a more specific example, try attaching a sample spreadsheet.

Cheers,

[FDibbins]

Sounds to me like you could use a vlookup for this?

Create a table with 1 column containing the minimum of a range, and the next contains the value you want