Originally Posted by JohnTopley 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks