106% to this please 6%
 

Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

Subtract 1???

=(A1/A2)-1



Steved wrote:

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

106% to this please 6%
 

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

On Oct 22, 1:54*am, Steved wrote:
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

=(A1-A2)/A2
Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steved" wrote in message
...
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

=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.




"Steved" wrote:

Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

You could try this...

=MOD(A1/A2,1)

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

--
Rick (MVP - Excel)


"Steved" wrote in message
...
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

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.
--
David Biddulph

Rick Rothstein wrote:
You could try this...

=MOD(A1/A2,1)

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


"Steved" wrote in message
...
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

Hello from Steved

I Thankyou Both

"Niek Otten" wrote:

=(A1-A2)/A2
Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steved" wrote in message
...
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.

106% to this please 6%
 

Good point... thanks for mentioning it.

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

Rick Rothstein wrote:
You could try this...

=MOD(A1/A2,1)

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


"Steved" wrote in message
...
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.