View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Arch Michael Arch is offline
external usenet poster
 
Posts: 32
Default 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.