Hello I am looking for a formula that will enable me to return the below values (points) for the below ranges. Thanks
$1000 to $2500 = 250 points
$2501 to $5000 = 300 points
$5001 to $10000 = 500 points
$10001 to $20000 = 800 points
>$20,000 = 1,000 points
Last edited by ensmith; 01-06-2015 at 10:30 AM.
Does this work
=if(a1>20000,1000,if(a1>10001,800,if(a1>5001,500,if(a1>2501,300,if(a1>1000,250,0)))))
Happy with my advice? Click on the * reputation button below
Or you could use a simple vlookup...
C2=value to search on
D2=VLOOKUP(C2,$A$2:$B$6,2,1)
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
Yes this worked thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks