Attributing a range scale to a percentage.

Originally Posted by WLM1976

Good Morning all,

I have a problem where i need to attribute a value based on a sales value. For Example if Cell A is less than £5100 that needs to be classed as 1, if it is inbetween £5100 & £7500 then it's 2 and so on. There are 10 sales brackets in total, any value over £25100 need to be 10. Because the value can include pounds and pence a VLOOKUP would be too big, is there anyway of solving this with a nested IF formula or something similar?

Thanks for any help.

Hi,

Why would a vlookup be too big? - you have 10 rows to VLookup 'True' to find the appropriate value rating.

hth
---
note lookup table
amount scale
0 ... 1
5100 2
7500 3
~~
25000.01 10

=Vlookup(value,Range,2,True)
should help you

---

Originally Posted by WLM1976

Thanks for that, completely forgot about using TRUE instead of FALSE at the end of VLOOKUP, as i normally use VL's to return specific cell data.

Thanks Again.

Thanks for the response