Forum Discussion

Copper Contributor

Feb 12, 2021

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...

excel

Twifoo

Silver Contributor

Feb 12, 2021

INSEWA

Wrap your formula with IFERROR, like this:

=IFERROR((T2-V2-W2)/(T2+U2),
"NA")

INSEWA

Copper Contributor

Feb 12, 2021

Twifoo I can't thank you enough! I knew there had to be something I was missing. I greatly appreciate your help with this 🙂 Have a wonderful day!

Twifoo
Silver Contributor
Feb 12, 2021
INSEWA
I'm delighted to have helped you.