Hello,
I am using excel 2007 for costing material for construction. I have a pricing spreadsheet which I've converted to a table. Current column headers are:
Description, Actual Material, Extra Material, Material, Material w/ Overhead
Actual material = My cost of material
Extra Material = Actual material + 15%
Material = Actual material + Extra Material
Material w/ overhead = Material + 25%
I want to consolidate all 4 columns to one column utilizing a formula. Could anyone tell me what's the most efficient way to do this?
Here's what I have so far but it comes out to be really long especially when you're working with tables on other sheets or named cells where the cell name would be much longer than just "A1" for example. In other words A1 would actually show as Materials!D31.
A1 = Actual Material cost
B1 = 15 % (extra material)
C1 = 25 % (overhead and profit)
Formula:
=(A1+(A1*B1))+((A1+(A1*B1))*C1)
Again, the above formula does seem to work, I'm looking for a more efficient way to write this formula.
Thank you,
-Travis
Bookmarks