# IF Formula for Finding numbers in a range?

1. ## IF Formula for Finding numbers in a range?

Hi folks,

I have a larger range of Sales Probabilities, and i want to group them in categories, for example:
- 0-25 = Step 1
- 25-50 = Step 2
- 50 - 75 = Step 3
- 75+ = Step 4.

I'm sure its simple, so sorry if this is a menial ask.

Thanks again.
Rohan F

2. ## Re: IF Formula for Finding numbers in a range?

if A1 is the cell your looking at
Formula:
`Please Login or Register  to view this content.`

alternative formula

Formula:
`Please Login or Register  to view this content.`

3. ## Re: IF Formula for Finding numbers in a range?

 F G 1 0 Step1 2 25 Step2 3 50 Step3 4 75 Step4

 A B 1 Data Formula Result 2 55 =VLOOKUP(A2,\$F\$1:\$G\$4,2,TRUE) 3 3 =VLOOKUP(A3,\$F\$1:\$G\$4,2,TRUE) 4 27 =VLOOKUP(A4,\$F\$1:\$G\$4,2,TRUE) 5 88 =VLOOKUP(A5,\$F\$1:\$G\$4,2,TRUE) 6 200 =VLOOKUP(A6,\$F\$1:\$G\$4,2,TRUE) 7 1 =VLOOKUP(A7,\$F\$1:\$G\$4,2,TRUE)

 A B 1 Data Formula Result 2 55 Step3 3 3 Step1 4 27 Step2 5 88 Step4 6 200 Step4 7 1 Step1

4. ## Re: IF Formula for Finding numbers in a range?

Thanks again folks for prompt responses, great forum we have here!

5. ## Re: IF Formula for Finding numbers in a range?

In regards to IF finding functions, is it possible to a between search, ie great than XX but less or equal XX ?

That would be handy to fine tune number ranges.

I tried doing it and got formula errors, so figuring i needed added layer of hypothesis.

Anyway thanks again for all the support.
regards
Rohan

6. ## Re: IF Formula for Finding numbers in a range?

if a1<26 = -negative whatever to 26
if a1<51 = must be above 26 but less than 51
if a1<76 = must be above 51 but lower than 76
A1 is none of these = must be above 76

if you want to tune the number ranges just change the numbers

put all 3 methods into one spreadsheet for you

7. ## Re: IF Formula for Finding numbers in a range?

Okay cool I get, the IF function finds values alternatively in each layer.

I thought maybe it would bring all values underneath for high levels of probability, but the nesting affect, suits me perfectly.
Thanks heaps

8. ## Re: IF Formula for Finding numbers in a range?

of course you can do it the other way starting from your max instead and using greater than

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1