Percentage UP

  • Thread starter Thread starter Gee
  • Start date Start date
G

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
 
I don't follow, but to increase by 50%:

=A1*1.5

or

=A1*150%

or

=A1+A1*50%

HTH
Jason
Atlanta, GA
 
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
 
Don't know another formula for faster, but slowercould be represented as

=1-MIN(C3:D3)/MAX(C3:D3)

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