how to set formula in worksheet

[bond]

Hi,
Can you please tell me what formulas to write in Excel2000 for a yes /no decision based on the following in a new worksheet?
Vehicle Cost

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

CD Player $100 O S O S
CD Changer $400 O O O O
Navigation $600 O O O O

ABS Brakes $800 O S S S
Traction Control $400 N S O S
Side Airbags $900 O S O S

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!

[bimmerman]

You need some criteria to calculate a yes/no decision (and a yes/no decision for what?) otherwise your spreadsheet is just totaling your options.