If you have an original value in A1 and a percentage increase in B1
(formatted as percentage), then the increased value =A1*(1+B1)
If B1 contains the percentage as a number (such as 10, rather than 10%),
then the formula is =A1*(1+B1%)
Perhaps a simple example will illustrate it ..
In A2 down are the source numbers, eg: 100, 200, etc
In B2 down are the percentage increases for each source number,
eg: 10%, 15%, ... (note that these are entered with the "%" sign)
You could put in C2: =A2*(1+B2)
and copy C2 down to return the required results
Any good? hit the YES below
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
