Pete,

Brilliant yet I wish I would have thought of it. I don't know why I was
stuck on the IF route. Thank you so much!!

"Pete_UK" wrote:

Set up a 2-column table somewhere like this:

0 0
51 0.05
201 0.1
501 0.2

and so on for your other values. Suppose this occupies cells X1 to Y8.

Then you can use this formula:

=VLOOKUP(D1,X$1:Y$8,2)

to return the appropriate factor depending on the value in D1. Copy
down as required.

Hope this helps.

Pete

On Aug 22, 1:04 am, Toria wrote:
In column D, I have units. I have to apply values to the number of units. If
the number is between 0-50 units, I apply 0, if between 51-200, I would need
to apply .05, if between 201-500, i would need to apply .10 and so on. The
numbers go above 10,000. Is this possible? I'm terrible at nested IFs. I
tried and kept getting errors and didn't see any similar questions.

Thank you!