You're welcome, Toria - thanks for feeding back.

Pete

On Aug 22, 2:20*am, Toria wrote:
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!- Hide quoted text -

- Show quoted text -