May 31 2022 02:05 PM
I am using this formula =SUM(60*I6)/(E6*F6) for a spreadhseet. If my cells are empty I would like to hide the error #DIV/0!. I have tried the IFERROR function but it says I have entered too few arguments. Can someone help me?
May 31 2022 02:21 PM
SolutionMay 31 2022 02:38 PM
@HERSRATER Good afternoon, use the function in this way =IFERROR(SUM(60*I6)/(E6*F6),"") or in your case the If function =IF(and(F6=0,E6=0),0,SUM(60*I6)/(E6*F6))
Jun 01 2022 09:58 AM
@flexyourdata Thank you! That works. Just trying to get that cell hide the error. Thanks again
May 31 2022 02:21 PM
Solution