I have this formula in Q13:
=IF(OR($Q19="2: 1/4";"2: halv");0.225*1*0.25;0.225*1*0.5)
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?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.