Forum Discussion

sanggu_'s avatar
sanggu_
Copper Contributor
Oct 11, 2024

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...
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 11, 2024

    sanggu_ 

    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.

Resources