Forum Discussion
Help with formula's and drop down lists
Hi all, I have 4 categories of which each category has a dropdown list with 3 choices. Once all categories have chosen a number from the drop down list, in a different cell I should be able to s...
Hi Jihad Al-Jarady,
It works and shows as 0 until I start choosing numbers from the drop down menu. As soon as I have chosen those, the formula shoes as #value!
It works and shows as 0 until I start choosing numbers from the drop down menu. As soon as I have chosen those, the formula shoes as #value!
Jihad Al-Jarady oh that's great!
I tried again and it's still not showing up for me. I have attached my screenshot so you can see. I'm not sure what i'm doing differently than you are.
The problem is caused by different system settings. Apparently, you use comma as decimal separator.
It's best to use a range as source for the data validation drop downs. This avoids the confusion.
See the attached workbook.
