Forum Discussion
#VALUE! error on simple formula using drop down menu from input cell
Hi
We run our business off spread sheets and having just moved to O365 from Google, I am having a major problem.
I get a #VALUE! error when multiplying a simple number (hours worked) by a billing rate (£ per hour). E.G =sum(8[hours worked]* £21.50 [billing rate]).
The billing rate is being drawn from a cell which has drop down options (£20.00, £20.50, £21.00, £21.50 etc). But I keep getting a #VALUE! error on excel browser, but it works fine in the app version.
Why is this?
Surely excel browser can calculate a simple formula if there is a drop down menu in an input cell?
Please help!!
9 Replies
same exact problem.
Alex_ST1015Sare it can, but can you upload a screenshot showing how exactly you enter the formula?
Riny_van_Eekelen Many thanks for your response. Please see below:
The billing rate column has the drop down in it, which pulls from a list of rates using Data Validation.
Alex_ST1015 I suspect that the billing rates are not recognised as numbers. How exactly did you set-up the data validation list?
By the way, you don't need the SUM function. Just =C6*D6 is sufficient.
