Add a percentage to a same cell value
Hello everyone
I have been trying to inflate same cell values by a percentage. The workbook I'm working on is a budget, and what I need to do is to inflate all figures by 7%
I have tried the Paste Special > Values > Multiply (having 0.07 in separate cell), but the result I get is 7% of the original value in the cell. Adding 0.07 within the formula also gives me 7% of the original value instead of original value + 7%
Can anyone please help??
Thanks
tryI have tried the Paste Special > Values > Multiply (having 0.07 in separate cell),
1.07
in a separate cell
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you so much, I knew the solution was an easy one but couldn't figure out! You're a life saver
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks