I have created an excel sheet to simplify pricing for my customers while offering them a visual experience showing them the pricing options, and savings by being a "plan member".
The difficulty I have, which is stopping me from progressing is this:
In the attached workbooks, I have the following sheets:
Labor Calculator
Set-Up
Flat-Rate Book
I am trying to populate the materials markup column in the flat rate book worksheet, based on a chart in the set-up sheet. "If the price is between X and Y on this sheet, then the multiplier will be Z on the other sheet.
I have searched high and low on google for how to accomplish this, with absolutely no luck. I know it Can be done, because I have seen it in other spreadsheets over the years and was not smart enough to save one for later (later being now) since I didn't think i'd ever need it.
Can anyone possibly provide me some guidance? The workbook is attached.
(The labor calculator sheet works perfectly and as intended)
Bookmarks