troubleshooting Question

In Excel 2007, how should I correct my IF ERROR formula to avoid #VALUE! error

Avatar of hermesalpha
hermesalphaFlag for Paraguay asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
15 Comments1 Solution249 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros