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
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.
Last edited by humdingaling; 06-23-2015 at 11:51 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Step1 Step2 Step3 Step4
Data Formula Result =VLOOKUP(A2,$F$1:$G$4,2,TRUE) =VLOOKUP(A3,$F$1:$G$4,2,TRUE) =VLOOKUP(A4,$F$1:$G$4,2,TRUE) =VLOOKUP(A5,$F$1:$G$4,2,TRUE) =VLOOKUP(A6,$F$1:$G$4,2,TRUE) =VLOOKUP(A7,$F$1:$G$4,2,TRUE)
Data Formula Result Step3 Step1 Step2 Step4 Step4 Step1
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks again folks for prompt responses, great forum we have here!
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
the IF is nested/layered already
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
Last edited by humdingaling; 06-24-2015 at 12:12 AM.
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
of course you can do it the other way starting from your max instead and using greater than
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks