How to Times a percent, and be able to change percent.

Ok i need help. I have a spreadsheet with about 20 rows right now. This sheet is going to be my template.

Let say F33 is my cell i am going to put the % i wanna mark stuff up. Like i put 8 in there to mark this project up 8%.

I have F5 that is the cost to do the project. So i wanna take F5 times F33 (which will be a percent markup) to equal and put in column G5. And then i will do this again for the row 6 etc.

Also realize i want that F33 to not be locked and set cause the next week i may want to change and put in 10 to make it a 10% for the next project.

THANKS and help,.

So in cell G5, enter =F5*F33
G5 should now show 8% of the project cost. If the percentage changes or the project cost changes, this value will update automatically.

You will want to use cells away from your data that will be your calculation cells - and you can hide these cells so it will all look automated.

I attached an example spreadsheet for you to review.

Hope it helps.

Example.xls