Hi,
I need a formula that will:
1) perform one calculation if a nearby cell (E31) is blank (if blank, then cost * markup)
2) Perform another calculation if it is populated and a second cell says "T&M" (if populated and "T&M, then takes the labor sell rate ($65) and multiplies by the quantity entered (E31)
3) Perform another calculation if it is populated and a second cell says "Estimate" (if populated and "Estimate" then takes labor cost rate and multiplies it by the MU (1.7) (F6) and multiplies that by the quantity entered (E31).
4) Remain blank if quantity is 0 and nothing is entered into the cost cell (I31)
I loaded the "experimental" workbook below."v3.3"
This calculation is more complicated that I can solve on my own, so I'm asking for help.
Thanks,
-Rod
Bookmarks