Hi everyone,
I have the calculator sheet where I have five drop-down boxes from "Data Sheet". Idea is to have the overall price for the customer of the service. So on the data sheet first of all we have:
1) Fixed cost, i.e. 1000€
2) Variable Cost 1: "John" and next block the price of John, i.e. "1000EUR"
3) VC2: "Sauna" - yes -no question, IF; yes; then "800EUR"
4) VC3: "Food" - With or w/o BF
5) VC4: "Lecturer" - Multiple options, a list in Column and next column the price of the particular lecturer
6) Multiplier: How many participants i.e. from 5 to 15 as minimum and maximum.
So Function: FX + Multiplier(VC1, VC2, etc) = Overall cost
Thanks in advance!
Pentti
Bookmarks