I have a panel that has drop a down of the following choices. I need help calculating from the dropdown. I need a formula that adds BasePrice (PC price) + Costs (dropdowns and checkboxes) I want the sum of BasePrice + Costs as a Total value output. so Individuals filling out the form can see what extra options does to the Baseprice.
currently my formula adds ($1400+$45) as $1409 which strange because it adds the $45 as 9 (4+5)?
1. Docking station None($0) Docking station($100)
2. Backpack None($0) company backpack($45)
3. Primary Monitor
4. Secondary monitor
USB (yes/No ) where yes ($20)