Have a feeling there might be an easy answer to this but struggling with the last part.
Currently I have two values
COLUMN A_new ....- ....COLUMN B_old
£13.31........................ £12.34
I've used this formula to calculate percentage increase:
=(New Price-Old Price)/Old Price
Which gives me a percent difference of 7.86%
However I want to then apply a percentage increase of 7.86% to another cell which currently shows £26.00
If I use this formula: =SUM(O3+N3) (with O3 holding the 7.86% answer and N3 having the value I need to amend), it works out as £26.08.
But increasing £26 by 7.86% should equal £28.04
Thank you for any help in advance
Bookmarks