Percentage UP

[Gee]

Help.
How do you get percentages to boost up. I know there are
2 different ways to figure the percentage of a number, I
just can't remember what they are.
Thanks,
Gee

 

[Jason Morin]

I don't follow, but to increase by 50%:

=A1*1.5

or

=A1*150%

or

=A1+A1*50%

HTH
Jason
Atlanta, GA

 

[Gee]

I have 2 numbers which represent speed.
28.932 per minute (Cell C3) and 17.651 per minute (Cell
D3).
I need to determine the percentage faster and slower so my
formula starts with which is faster being represented
by "Company A" or "Company B".
cell E3:
=IF(C3>D3,("Co. A"),("Co. B"))
Then, to get my faster/slower percentages, Cell G3:
=IF(E3="Co. A",((C3/D3)-100%),((D3/C3)-100%))
And Cell H3:
=100%-G3
I end up with G3 as 63.91% and H3 as 36.09%
There is another mathematical method to get to these
percentages and sometimes you get a slightly different
number using that other method. Anyone know what it is?
I'd really appreciate any help, this is drivin' me nuts.
Thanks in Advance,
Gee

 

[JE McGimpsey]

Don't know another formula for faster, but slowercould be represented as

=1-MIN(C33)/MAX(C33)

which would give the slower being 38.99% slower than the fastest.