AnsweredAssumed Answered

Calculating from a dropdown

Question asked by ahoror on Jun 27, 2018

Hi,

 

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)?

                                                          choices

1. Docking station                          None($0) Docking station($100)

2. Backpack                                  None($0) company backpack($45)

3. Primary Monitor

4. Secondary monitor

checkboxes

USB (yes/No ) where yes         ($20)

Outcomes