106% to this please 6%

[Steved]

Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

 

[Dave Peterson]

Subtract 1???

=(A1/A2)-1

Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

 

[muddan madhu]

=B7/B8-1
or
=32297966/30400962 -1

 

[Niek Otten]

=(A1-A2)/A2
Format as %

 

[Michael Arch]

=1-(A2/A1)
If you place this on A3 and your numbers are in A1 and A2. Then format as %
--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.

 

[Rick Rothstein]

You could try this...

=MOD(A1/A2,1)

and format the cell as percentage (specifying the number of decimal places
you want).

 

[David Biddulph]

I wouldn't recommend MOD(...,1) as a general solution.
It's OK if A1/A2 is between 1 and 2, but as a more general solution you'd be
better off with =(A1/A2)-1, assuming (of course) that the OP is looking for
the percentage increase.

 

[Steved]

Hello from Steved

I Thankyou Both

=(A1-A2)/A2
Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[Rick Rothstein]

Good point... thanks for mentioning it.