Formula Error-#DIV/0!

[apinter]

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?

[#2 · Accepted solution]

@apinter 

Perhaps

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

[#3]

It worked! Thank you so much!! 🙂

[#4]

@apinter , you are welcome