User Profile
INSEWA
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
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 cells are 0 =(T2-V2-W2)/(T2+U2) I greatly appreciate any help! I have tried various ways with IF but nothing is working and I am sure it must be able to be done LOL
