With 1000 in B1, enter this formula in H2:
=(A1-B1)/B1
or, without B1, (A1-1000)/1000
It will show 0.048. Now FormatCellNumber, choose Percentage with 2
decimals.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"News Account" wrote in message
...
Hi
I'm new to spreadsheets and I suspect this problem is very easy to solve,
G2
is a value of £1048.00. In H2 I want to show this as a percentage gain
from
a starting point of £1000.00 ie 4.8%. I would like H2 to show 4.8% or
4.80%. I'm going round in circles.....
Many thanks :-)
|