G
Guest
I have a worksheet that uses a formula that subtracts tha amount from one
column from another. If nothing is entered in the first column a zero is
calculated and shows up in the second column. I save my sheet as csv file and
run it thru a cnc machine map reader and it does not like the zeros, I have
to manually go into the csv file and delete the zeros for it to work. how can
write or format the formula so if the resul is zero not to enter anything
into that cell
column from another. If nothing is entered in the first column a zero is
calculated and shows up in the second column. I save my sheet as csv file and
run it thru a cnc machine map reader and it does not like the zeros, I have
to manually go into the csv file and delete the zeros for it to work. how can
write or format the formula so if the resul is zero not to enter anything
into that cell