While a Vlookup is certainly an option if you want to take up more real
estate, have you abandoned the idea of using IF statements even though I
showed you how to do it? Just curious why your continuing to struggle when
you could just copy in the solution.

--
Regards,
Tom Ogilvy


"Tom Tucker" wrote in message
...
I need for the search to look through the following criteria:

Less than 1 =400
1 but less than 2 =300
2 but less than 4 =250
4 but less than 6 =150
6 but less than 8 =125
8 but less than 10 =100
10 but less than 12 =92.5
12 but less than 15 =85
15 but less than 22.5 =70
22.5 but less than 30 =65
30 or greater =60

so if the number is 7.95, I need for it to enter 125.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!