Longtime fan from the TechTV days. Have a question on applying formula to highlighted cells

[CptRameus]

Good afternoon. In my job, I receive cost invoices that I must convert over to sell invoices. Since markup is typically static across multiple lines of the invoice, is there a way for me to apply markup percentage to the cells that I highlight and replace those results right back into the cells I've highlighted? At the moment I have to either create a new column adjacent to the cost column or in a new copied workbook and manually calculate and enter the new "sell price" column. The calculations can then be "fill tabbed" into others below, but I still need the cost column there for the function to work. I'd like to just add my markup, replace the values in the cost column and then change the "cost" column header text to "sell price". As with anything in Excel I'm looking to save time and minimize errors. Kinda obvious. I've seen something from Kutools (?) that allows a function =(?*1.4) for example where ? is the value of the chosen cell. Is this what I need? Is this only available third party?

I'd be happy with a hotkey that could apply my formula to any cell I highlight using the value in that cell and replace that new value into the same cell. Is this a tall order for an Excel noob?
Thank you all
Cpt

 

[MikeWx]

If you put your markup percentage into another cell and copy it, you can highlight the cost values and select Paste Special Multiply and the cost values will be recalculated. A 10% markup would have a value of 1.10.