condition
I am creating a macro to calculate sum of the cells in
column. In a cells itself I have IF formulas which
calculate value based on other cells in the row and
display result if it is greater than 0 or display nothing
("") if it is 0. I am receiving error when the value in
the cell is 0. How I can modify my macro so that it will
allow 0 and will not try to add "" to the number ?
Thanks for help.
Tony
|