Multiply total project cost by percentage to get sale price

Mike Farmer

Hello! This is my first post, and I know the answer is simple, but here it goes:

I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column.

Eventually I want to be able to add subtotals and do the same thing, but perhaps a different markup per subtotal, that then feeds the "Extended Price" column.

Does anyone have advice on the calculations I need to add?

Thanks for reading, and for any help you can offer.

M

J. Craig Williams

Mike,

 

In the [Extended Price] column, add this formula (this is for row 23)

 

=[total project cost]23 * [percentage]23

 

This is the reference you should start with:

 

https://help.smartsheet.com/articles/775363-using-formulas

 

Craig

Mike Farmer

Thanks Craig, I will give this a go on monday!