I made a template with my formulas and I have some lines that I need to put
zero's in so I won't get #VALUE! where my formula is. For example: J16*K17
is the formula for L17. I have to put zeros in my J & K columns if I'm not
using them or my L17 shows #VALUE! The first 5 or so lines do it but then
the rest are fine. The other L cells just have zeros until I put in the
figures that I want in the J & K. If I'm doing a quote and don't use all the
lines, I get these errors on the unused ones.
Hope I'm not being too confusing! Help!!!
--
Mary Lou