Hi,
Can you please tell me what formulas to write in Excel2000 for a yes /no decision based on the following in a pricing worksheet?. This pricing sheet is the place for the user to select the car they would like to purchase and their desired option. Eg. in Y? column, put a Y(yes) for chassis type and put Y in the relevant options sections, will produce (base car price + gadgets + safety + luxury options total price in another area of worksheet).
Vehicle Cost
Chassis type Key:
Sedan $24,990 S: Standard Feature
Deluxe $32,990 O: Optional Feature
Wagon $27,990 N: Not Available
Coupe $35,990 C: No Cost Option
Options Summary
Option Price Sedan Deluxe Wagon Coupe
gadgets
CD Player $100 O S O S
CD Changer $400 O O O O
Navigation $600 O O O O
safety
ABS Brakes $800 O S S S
Traction Control $400 N S O S
Side Airbags $900 O S O S
luxury
Cruise Control $150 O S O S
Automatic Tr $2,000 O S O O
Metallic Paint $300 O C O C
Leather Interior $1,500 O O N S
1. Price column of options populate with availability and cost of each option
2. If no chassis selected or if more than 1 type selected, price field of all options read “car”
3. Optional feature in currency form, “standard” in grey, “no cost” in green, and “n/a” in red.
Please help!
Can you please tell me what formulas to write in Excel2000 for a yes /no decision based on the following in a pricing worksheet?. This pricing sheet is the place for the user to select the car they would like to purchase and their desired option. Eg. in Y? column, put a Y(yes) for chassis type and put Y in the relevant options sections, will produce (base car price + gadgets + safety + luxury options total price in another area of worksheet).
Vehicle Cost
Chassis type Key:
Sedan $24,990 S: Standard Feature
Deluxe $32,990 O: Optional Feature
Wagon $27,990 N: Not Available
Coupe $35,990 C: No Cost Option
Options Summary
Option Price Sedan Deluxe Wagon Coupe
gadgets
CD Player $100 O S O S
CD Changer $400 O O O O
Navigation $600 O O O O
safety
ABS Brakes $800 O S S S
Traction Control $400 N S O S
Side Airbags $900 O S O S
luxury
Cruise Control $150 O S O S
Automatic Tr $2,000 O S O O
Metallic Paint $300 O C O C
Leather Interior $1,500 O O N S
1. Price column of options populate with availability and cost of each option
2. If no chassis selected or if more than 1 type selected, price field of all options read “car”
3. Optional feature in currency form, “standard” in grey, “no cost” in green, and “n/a” in red.
Please help!