Sliding Percentage Scale
A set low number of 100 is in cell B4, and a related set high percent of 18% is in cell B6.
A set high number of 1,000 is in cell D4, and a related set low percent of 14% is in cell D6.
In cell B8 a manual number will be typed between 100 and 1,000.
In cell B10 we want a formula that will roundup a percentage number between 14% and 18% depending on the number inserted in B8.
Regards, Gary
Sorry, Gary, you lost me.
14 and 18% of what?
So in your example, if we enter 700 in B8. 14% of that is 98, 18% is 126. How do 100 and 1000 enter into it?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for checking ChemistB.
The 14% is the percent if the number is 1,000.
The 18% is the percent if the number is 100.
The slide would be a number between 100 and 1,000, resulting in a percentage between 14% and 18%.
Example, a number of 500 would most likely roundup to 16%.
Thanks, Gary
You can use the FORECAST function but the x and y values need to be in next to each other and not separated by cells. I did this on the attached by referencing B4,B6,D4 and D6 in H1:I2. Then the formula becomes
=FORECAST(B8, $H$2:$I$2,$H$1:$I$1)
formatted as Percentage
If you need it to be really rounded for additional calculations
=ROUND(FORECAST(B8, $H$2:$I$2,$H$1:$I$1),2)
Last edited by ChemistB; 06-18-2014 at 10:29 AM.
ChemistB, sorry for the long delay, had to step out.
This is perfect. Thanks much for your time and expertise.
Regards, Gary
ChemistB,
One additional question.
Is it possible to "round" the Forecast formula to the nearest .5 (1/2)?
Thanks, Gary
Yes,
MROUND(FORECAST(B8, $H$2:$I$2,$H$1:$I$1),0.005)
Great, this works perfect.
Thanks again ChemistB.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks