Then in Q19 I have a drop-down list with these values:
-
2: 1/4
2: halv
Note that the first value in this drop-down list is a - with several blank spaces before and after it. I suspect this might cause this #VALUE! error.
I get this #VALUE! error even after I have selected a valid option in the drop-down list (e.g. "2: 1/4").
Other things that might cause this could be formatting, such as centering of the contents in Q13 and Q19.
Or is there any wrong with my formula? How should I correct this so I get the calculation performed after having selected a valid option in the drop-down list?
I entered your formula, and the #VALUE! error disappeared. But the calculation in Q13 should be performed when valid option has been selected in the drop-down list, now it does not. It should be displayed the result of the calculation in Q13 (which is 0.06 as I have formated Q13 as number with 2 decimals). Nothing is displayed in Q13 now.
I get result calculated now when I add one more "Q19", but the result is wrong for the second option selected (correct only for the first option in the drop-down list selected). And if I select another value (not any of these two values, or the first option " - ", then I get wrong result (0.11).
Shums Faruk
Can you upload your sample workbook?
Shums Faruk
For every value you gonna add in Drop Down List, you need to add in your OR statement, suppose you added Q19 = 2: 3/4
I know what is wrong now: The formula in fact says that if Q19=2 1/4 OR Q19=2: halv OR Q19=2: 3/4, then the first result, otherwise (if false), the last result.
Open in new window