Forum Discussion
Formula for giving multiple results
I am trying to modify the following formula so that if all cells have 0 entered in them the result will be NA otherwise it will calculate the accuracy rate; Currently it shows #DIV/0! if all the cell...
You are getting error #DIV/0!, because you have ignored the basics,, Excel shows the #DIV/0! error when a number is divided by zero, or when a formula refers to a cell that has 0 or is blank, as shown in this screen shot you have ZERO in T2,V2, & in U2 also, just below formula works properly since has few values are greater than Zero !!
And to trap the error, you may use IFERROR built in function.
=Iferror(T2-V2-W2)/(T2+U2),"")
or
=Iferror(T2-V2-W2)/(T2+U2),"NA")