Forum Discussion
Need help with this error #DIV/0!
In column S you have texts like "$100", not numbers formatted as currency. Select column S, Ctrl+H and replace $ on nothing. It works. After that you may apply currency format to that column.
Quite strange. This formula shall work exactly the same way in Excel for Web and in Desktop, practically for any version of Excel Desktop. Why the latest doesn't recognize "Youth (<25)" in column G, assuming you did no changes in the file includes any copy/paste, is not clear.
Perhaps you may share the file to check, removing from it all sensitive information, actually keeping only columns G and S plus cell with the formula.
SergeiBaklan That's what I thought too. I have a feeling that the problem is just within the file cos I just reinstalled my 365 and it's still the same. I tried using the same function with different data files, and it works fine.
I would appreciate it If you could look at it too to see the possible issue. Thank you!In column S you have texts like "$100", not numbers formatted as currency. Select column S, Ctrl+H and replace $ on nothing. It works. After that you may apply currency format to that column.
- It worked. Thank you!
