Forum Discussion
Oonar1600
Nov 28, 2022Copper Contributor
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...
HansVogelaar
Nov 28, 2022MVP
Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.
- Oonar1600Nov 28, 2022Copper ContributorI did my best. Here is a link you can use. I hope it works.
https://we.tl/t-Mq5OjZneax- Nov 28, 2022
- Oonar1600Nov 28, 2022Copper ContributorHi 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!