View Single Post
  #1   Report Post  
Juco
 
Posts: n/a
Default How to display a blank cell with no error message

when i clear all the cells in the formula below I get #VALUE! showing in
the cell (M15)
Is there a way to just show a blank cell? and not have this message
showing.

thanks

=M7+M8+M13+M14