Posted 8 September 2017, 1:40 pm EST
I have a number cell type to which i set a formula like PRODUCT(A1,B1)
where both A1 and B1 cells are empty.
However my result cell shows a default value of "1.0". The number cell type has once decimal place set.
Unable to get rid of this default value. Please help.