Here is what I'm trying to do.
I'm trying to calculate a price based on 4 columns, 3 of which are Combo boxes.
IE:
Columns are:
Trim Size
- Small Trim
- Large Trim
Format
-SGML
-InDesign
-Quark
-hardcopy
# of Pages (entered manually)
English
-Yes
-No
Price (this is calculated based on the previous fields)
On sheet2 I have the amounts in a table:
--------------- Small Trim------- Large Trim
SGML -------------- 1 ---------- 1.5
InDesign ------- 1.15 ----------- 1.7
Quark ---------- 1.4 -------------- 2.1
Hardcopy ------- 2.35 ------------- 3.3
If English is Yes 20% 30%
Is there are way to calculate this easily? I know VBA if I built a new form, but the person I'm working on this for wants it in Excel spreadsheet and I can't figure it out. Any help would be appreciated.
IE: If the user wants to know the price of 25 pieces of small trim, InDesign format, in English. It would be (1.15 * 25) * .20 = Price
Bookmarks