You guys are so awesome!
I am looking for a way to say
IF A2>9 then B2 returns bronze
IF A2>24 then B2 returns Silver
IF A2> 49 then B2 returns Gold
IF A2>99 then B2 returns Platinum
THANKS!
tom
You guys are so awesome!
I am looking for a way to say
IF A2>9 then B2 returns bronze
IF A2>24 then B2 returns Silver
IF A2> 49 then B2 returns Gold
IF A2>99 then B2 returns Platinum
THANKS!
tom
Hi TomRet,
An IF(OR ... statement should do it for the result in Cell 'A2'.
Then you would need a Conditional Formatting Formula to shade the Cell 'B2'.
Hth
Remember you are unique, like everyone else
a Merry Christmas to you, Tom. an IF formula would probably be something like:
=IF(A2>99,"Platnium",IF(A2>49,"Gold",IF(A2>24,"Silver",IF(A2>9,"Bronze",""))))
if it's always integers, maybe also consider:
=LOOKUP(A2,{10,25,50,100},{"Bronze","Silver","Gold","Platnium"})
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Here's the Formula;
This puts the text into Column 'C' based on the condition.Please Login or Register to view this content.
Hth
noboffin, if you start with the largest and work down to the smallest, you can do away with the AND()'s
edit: I just saw that Ben already did it that way
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Awesome guys! I used Ben's (Merry Christmas to you as well!) integer system although I didn't think it would work since the numbers may not always by 10, 25,....but even with 80 it works just fine. One thing, would it be possible to put in a clause to make it return blank ("") or would I need to go with the other formula for that?
Cheers
Tom
Good tip, thank you
maybe...
=if(A2=0,"",LOOKUP(A2,{10,25,50,100},{"Bronze","Silver","Gold","Platnium"}))
Fantastic! Actually all of these formulas work.
fdibbins: I made one minor modification to make yours work for my purposes;
=IF(Q3<10,"",LOOKUP(Q3,{10,25,50,100},{"Bronze","Silver","Gold","Platinum"}))
Thanks so much and Merry Christmas
Tom
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks