I would appreciate help finding the function for the % change and the answer. Thank you so much.
Share Value
7/31/2000----------$19.800
7/31/2001----------29.96
% Change (compute the percentage of change - 1 decimal place)
I would appreciate help finding the function for the % change and the answer. Thank you so much.
Share Value
7/31/2000----------$19.800
7/31/2001----------29.96
% Change (compute the percentage of change - 1 decimal place)
Normal way would be
=B2/B1-1
where B1 contains initial value and B2 new value
format cell as perecntage to 1 decimal place, I calculate the answer as 51.3%. Of course this is an increase, a decrease would be shown as a negative percentage
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks