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

"Alexis" wrote in message
...
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!!

Maybe just taking 60% of your result would be enough???

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

or just
=60%*(YourOriginalFormulaInA1Here)



Alexis wrote:

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!!

--

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.

"Alexis" wrote:

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!!

Or, to keep it closer to your problem definition:

=A1*(60%/100%)

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
=A1*.6

--
Kind regards,

Niek Otten

"Alexis" wrote in message
...
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!!

Try the following:
=IF((A1*60%)<=60%,(A1*60%),60%)


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=494654