Forum Discussion
Alex_ST1015
Apr 12, 2022Copper Contributor
#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 ...
Alex_ST1015
Apr 13, 2022Copper Contributor
The validation list is in another tab and simply a list of numbers, formatted to £(currency).
Riny_van_Eekelen
Apr 13, 2022Platinum Contributor
Alex_ST1015 Attaching a working example. Perhaps you can work out what's different in your file.
- Alex_ST1015Apr 13, 2022Copper ContributorHi 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.- Riny_van_EekelenApr 13, 2022Platinum Contributor
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.
- Alex_ST1015Apr 13, 2022Copper ContributorHi 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.