Increase amounts in a specific column with a percentage as an annual increase

Question

Good day all&nbsp;Thanks for this platform. Im really new and have very little knowledge regarding formulas and excel but desperately require assistance in increasing my current sheet of clients monthly fees with 8%. I have exported the file from my debit order system and need to import it again after increasing all the amounts with 8%.&nbsp;Could someone please assist me on how to increase the whole column's amounts with 8%. Would really appreciate your assistance.&nbsp;

lorenzo · Answer

Hi&nbsp;RochelleB&nbsp;&nbsp;Assuming 1st Amount in A2, in B2: =A2*1.08then copy down till the end of colum

nikolinode · Answer

RochelleB&nbsp;Attached is a sample file with a whole simplified solution.Hope this helps you.

Forum Discussion

Increase amounts in a specific column with a percentage as an annual increase

2 Replies

Resources