Forum Discussion
Solved
Need help with this error #DIV/0!
Hi, I am using AVERAGEIF to get a specific average in a particular group but I kept getting the error #DIV/0! using the excel application. But each time I use the excel browser, I get the outcome...
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.
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!
sanggu_ , you are welcome