Hi Everyone
Hopefully this will be a straightforward one that someone is able to assist with.
Basically I have a column of figures and a column of percentages, and what I want to do is incorporate a formula so when I add in the percentage the next column brings back what that actual amount would equate to - Please see the below example.
A1: 2,000
B1: 10%
C1: =200
I appreciate it would be a lot easier the other way around, to have the 2 figures and to give me a percentage each time, but I am needing to include this on a sheet that I have been working on for some time so it would be a great deal of manual work to change.
Thanks in advance for any help
Regards
James
Bookmarks