#DIV/0! shows up in cells S2, S5 & S8 when calculating an average. The formula works correctly, but I would like these cells to be blank unless calculations are entered in their appropriate places. Please see attached example.
#DIV/0! shows up in cells S2, S5 & S8 when calculating an average. The formula works correctly, but I would like these cells to be blank unless calculations are entered in their appropriate places. Please see attached example.
Last edited by LAWitcher; 01-04-2022 at 11:47 PM. Reason: Typo
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It is exactly the same principle as your previous thread - why are you effectively asking the same question again?
I gave you this:
=IF(OR(A2="",E2="",F2=""),"",E2/F2)
Just adapt the bit in red for the new situation.
Or you can trap the error like this:
=IFERROR(your_formula,"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks