S
shazmaz
Can anyone please tell me what logical formulas to write in Excel2000 for a
yes
/no decision based on the following in a pricing worksheet?. The criteria
is to set a pricing sheet where user can select the car they would like to
purchase and their desired option. Eg. in a column, put a Y(yes) for
chassis type and put Y in the relevant options sections, producing base
car price + gadgets + safety + luxury options and 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
(C,S and N=$0)
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 T $2,000 O S O O
Metallic Paint $300 O C O C
Leather Interior $1,500 O O N S
Criteria:
1. Price column of options populate with availability and cost of each
option.ie if I select "Y" in sedan column then all options (O) should come
up as currency form and the "N" as "n/a" in red colour.
2. If no chassis selected or if more than 1 type selected, price field of
all options read “carâ€
3. when Optional feature selected, should be in currency form, “standard†in
grey, “no cost†in green, and “n/a†in red.
Please help!
yes
/no decision based on the following in a pricing worksheet?. The criteria
is to set a pricing sheet where user can select the car they would like to
purchase and their desired option. Eg. in a column, put a Y(yes) for
chassis type and put Y in the relevant options sections, producing base
car price + gadgets + safety + luxury options and 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
(C,S and N=$0)
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 T $2,000 O S O O
Metallic Paint $300 O C O C
Leather Interior $1,500 O O N S
Criteria:
1. Price column of options populate with availability and cost of each
option.ie if I select "Y" in sedan column then all options (O) should come
up as currency form and the "N" as "n/a" in red colour.
2. If no chassis selected or if more than 1 type selected, price field of
all options read “carâ€
3. when Optional feature selected, should be in currency form, “standard†in
grey, “no cost†in green, and “n/a†in red.
Please help!