Forum Discussion
Formula Question
Could you please clarify that on the sample. In particular, sum of what?
SergeiBaklan thank you for responding.
It has to do with applying a markup percentage to a sum of reference cells. The reference cells are labor hours that are calculated by a formula that takes sq ft and divides by production rate, example is =sum(b12/h12). That value, we will call value A goes to another formula we will call "markups" to perform =sum(value A*1.17). My question is how do i create a rule in the markups formula so when I make a copy of the value A formula it automatically adds the copy to the markups formula.
Is this possible?
Let say in cell C12 you have the formula =B12/H12 (value A). You copy it to the cell C13 which will be calculated as =B13/H13. etc.
Markup formula in some other cell could be like
=SUM(C12:C20)*1.17
But it all depends on how exactly your data is structured.