Hey team with my limited knowledge of excel i am stuck with this. This is my formula:
=IF(ISERROR((SUM(G5,L5,Q5,V5,AA5))),"-",(SUM(G5,L5,Q5,V5,AA5)))
Instead of "0" (zero) appearing when their are no numbers to add, i need the cell to be blank. What do i need to change ?
Thanks, Roy
=IF(ISERROR((SUM(G5,L5,Q5,V5,AA5))),"-",(SUM(G5,L5,Q5,V5,AA5)))
Instead of "0" (zero) appearing when their are no numbers to add, i need the cell to be blank. What do i need to change ?
Thanks, Roy