G
Guest
I have a problem, I'm trying to run the following formula
(=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
which is to find out the average of a weekly call survey but some cells are
blank due to the fact that there are no value inputed because no calls where
made on specific day and the end result turns up an error (#DIV/O!). How can
I make it so if the cells are blank, the end result will turn to display zero?
(=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
which is to find out the average of a weekly call survey but some cells are
blank due to the fact that there are no value inputed because no calls where
made on specific day and the end result turns up an error (#DIV/O!). How can
I make it so if the cells are blank, the end result will turn to display zero?