software

I have a bunch of percentages that are on a 100% scale, but i need to create
a formula in excel that would scale it down to a 60% scale.

for example i need create a function that would prevent 89.72% from
exceeding 60%, i know the answer is 53.83%, but i don't know how to come up
with to formula to calcualte that.

im guessing i would use an IF THEN formula, =IF, but im not for sure.

your help is appreciated. thanks!!=A1*.6

--
Kind regards,

Niek Otten

quot;Alexisquot; gt; wrote in message
...
gt;I have a bunch of percentages that are on a 100% scale, but i need to
gt;create
gt; a formula in excel that would scale it down to a 60% scale.
gt;
gt; for example i need create a function that would prevent 89.72% from
gt; exceeding 60%, i know the answer is 53.83%, but i don't know how to come
gt; up
gt; with to formula to calcualte that.
gt;
gt; im guessing i would use an IF THEN formula, =IF, but im not for sure.
gt;
gt; your help is appreciated. thanks!!
gt;
Maybe just taking 60% of your result would be enough???

If A1 held the original value:
=60%*a1

or just
=60%*(YourOriginalFormulaInA1Here)
Alexis wrote:
gt;
gt; I have a bunch of percentages that are on a 100% scale, but i need to create
gt; a formula in excel that would scale it down to a 60% scale.
gt;
gt; for example i need create a function that would prevent 89.72% from
gt; exceeding 60%, i know the answer is 53.83%, but i don't know how to come up
gt; with to formula to calcualte that.
gt;
gt; im guessing i would use an IF THEN formula, =IF, but im not for sure.
gt;
gt; your help is appreciated. thanks!!

--

Dave Peterson

It looks like you just multiplied the input (89.72% in your example) by .6.
That would map the range 0-100% down to 0-60%. If your input is in A1, then
=a1*.6, formatted as a percent, would do this.

quot;Alexisquot; wrote:

gt; I have a bunch of percentages that are on a 100% scale, but i need to create
gt; a formula in excel that would scale it down to a 60% scale.
gt;
gt; for example i need create a function that would prevent 89.72% from
gt; exceeding 60%, i know the answer is 53.83%, but i don't know how to come up
gt; with to formula to calcualte that.
gt;
gt; im guessing i would use an IF THEN formula, =IF, but im not for sure.
gt;
gt; your help is appreciated. thanks!!
gt;

Or, to keep it closer to your problem definition:

=A1*(60%/100%)

--
Kind regards,

Niek Otten

quot;Niek Ottenquot; gt; wrote in message
...
gt; =A1*.6
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Alexisquot; gt; wrote in message
gt; ...
gt;gt;I have a bunch of percentages that are on a 100% scale, but i need to
gt;gt;create
gt;gt; a formula in excel that would scale it down to a 60% scale.
gt;gt;
gt;gt; for example i need create a function that would prevent 89.72% from
gt;gt; exceeding 60%, i know the answer is 53.83%, but i don't know how to come
gt;gt; up
gt;gt; with to formula to calcualte that.
gt;gt;
gt;gt; im guessing i would use an IF THEN formula, =IF, but im not for sure.
gt;gt;
gt;gt; your help is appreciated. thanks!!
gt;gt;
gt;
gt;

Try the following:
=IF((A1*60%)lt;=60%,(A1*60%),60%)--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=494654