Quote Originally Posted by JohnTopley View Post
If we still calculate if C6=0

=if(e6=0,"",c6+$c$3/E6)
This formula resolved the issue when C6 value is 0, but when E6 value is 0 and c6 has a value it returns a
error "#value!" It helped the C6 issue, but caused the e6 error.