samiam41
asked on
Excel formula to get past div/0 error
Hey experts. Pretty simple equation I'm trying to use but keep getting the div/0 error so I decided to post the question. I tried following the steps here (https://www.timeatlas.com/excel-divide-by-0-error/) but my simple mind couldn't grasp it.
Player 1-> 5 shots, 0 goals (should be 0% accuracy but I get error instead)
Attached spreadsheet for reference. Thank you in advance for your help.
EE_Accuracy.xlsx
Player 1-> 5 shots, 0 goals (should be 0% accuracy but I get error instead)
Attached spreadsheet for reference. Thank you in advance for your help.
EE_Accuracy.xlsx
ASKER
Hi Roy. That prevents the error but doesn't show 0% which is what the player's accuracy would be.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Quick and easy. Thanks!
ASKER
If anyone has any time, I would appreciate your help!
https://www.experts-exchange.com/questions/28948558/Excel-Display-number-of-cells-with-value-greater-than-0-in-range-of-cells.html
https://www.experts-exchange.com/questions/28948558/Excel-Display-number-of-cells-with-value-greater-than-0-in-range-of-cells.html
=IFERROR(C2/B2,"")