help.. too difficult to put into words

[Alexis]

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

[Niek Otten]

=A1*.6

--
Kind regards,

Niek Otten

"Alexis" <[email protected]> wrote in message
news:[email protected]...
>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]

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

[bpeltzer]

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

[Niek Otten]

Or, to keep it closer to your problem definition:

=A1*(60%/100%)

--
Kind regards,

Niek Otten

"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> =A1*.6
>
> --
> Kind regards,
>
> Niek Otten
>
> "Alexis" <[email protected]> wrote in message
> news:[email protected]...
>>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!!
>>
>
>

[wjohnson]

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