Hey all, I searched but found no answer so I put it to you.
I need to sum up the results of formulas to do further calculations, but some cells have #NA in them if the data was not entered. I need the #NA to show up as zero, can I add this to the formula that is there already?
Thanks
I need to sum up the results of formulas to do further calculations, but some cells have #NA in them if the data was not entered. I need the #NA to show up as zero, can I add this to the formula that is there already?
Thanks