106% to this please 6%

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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.
Click to expand...
 
=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.
 
You could try this...

=MOD(A1/A2,1)

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