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 formula we can add to the above to leave Q7 blank until K&G 7 are filled in?

Formulas and Functions

5 Replies

  • apinter's avatar
    apinter
    Copper Contributor
    Jan 15, 2025

    Hello! Any chance you might be able to assist with another formula we are stumped on?
    We have this formula =IF((K7/P7)>+0.5, "PASS", "FAIL"), If K7 or P7 are empty we get #VALUE!, what can we add to the formula to make the empty cells show "NA"?
    Thanks for any assistance!

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 18, 2025

      apinter , that could be

      =IF( OR( K7="", P7="" ), "N/A",
 IF( K7/P7 > 0.5, "PASS", "FAIL")
)

       

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 27, 2024

    apinter 

    Perhaps

    =IFERROR( IF(MAX(ABS(1-(K7/G7)),ABS(1-(G7/K7)))<0.1,"PASS","FAIL"), "" )

Resources