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 ...
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.
- The validation list is in another tab and simply a list of numbers, formatted to £(currency).
Alex_ST1015 Attaching a working example. Perhaps you can work out what's different in your file.
- Hi Riny
I have downloaded and this works fine and exactly as i would expect. The problem only occurs on the browser version of excel, rather than the app version. I seem to have tried everything.
I really appreciate your help on this as desperate for a solution.