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 ...
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.Alex_ST1015 Hardly ever use the on-line version so can't really tell. But it should work the same as in the desktop version.
Perhaps you can share a link to the file with the problem you describe. Then I, or someone else, can open it in Excel for the Web and have a closer look.
- Hi Riny, problem is fixed. There is a weird quirk where the drop down list numbers must be formatted General on the browser (not same case on app version where they can be currency or number).
Many thanks for your help on this.