Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|