How to set formulas in worksheet?

[yog]

Hi,
Can you 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 are to set a pricing sheet where user can 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
(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 Tr $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
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!

 

[Mel Smith]

I'm not sure if I've really understood the problem but offer the following as a start point. Assume "option" is in Cell a2 and "cost" is in cell b2 and the "Y?" is in cell c2. In cell c2 ... =if(b2="Y", a2,0) and then simply total these figures.

I hope this helps.

Mel