Forum Discussion

apinter's avatar
apinter
Copper Contributor
Aug 27, 2024
Solved

Formula Error-#DIV/0!

We are using this formula in Q7 - =IF(MAX(ABS(1-(K7/G7)),ABS(1-(G7/K7)))<0.1,"PASS","FAIL"), it works great, except: when K7 & G7 don't have amounts in them, we get the #DIV/0! error. Is there a form...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 27, 2024

    apinter 

    Perhaps

    =IFERROR( IF(MAX(ABS(1-(K7/G7)),ABS(1-(G7/K7)))<0.1,"PASS","FAIL"), "" )
SergeiBaklan's avatar
SergeiBaklan
MVP
Aug 27, 2024

apinter 

Perhaps

=IFERROR( IF(MAX(ABS(1-(K7/G7)),ABS(1-(G7/K7)))<0.1,"PASS","FAIL"), "" )
  • apinter's avatar
    apinter
    Copper Contributor
    Aug 27, 2024
    It worked! Thank you so much!! 🙂

Resources