How keep Excel from counting empty cells when calculating form
=PRODUCT(J2,100/G2)
I'm doing a percentage formula. It works when the denominator is present,
and I even tried it without the 100 factor but that didn't work either. I
suppose another option would be if I would get Excel to tell me that J2 is x
percent of G2. Don't know how to do that either. :-)
"Pete_UK" wrote:
Post your formula, then we can comment on it directly.
Pete
On Nov 8, 10:30 pm, Excel Noob <Excel
wrote:
I have plotted out a worksheet, but the problem is that it is trying to
calculate empty cells as having a value of zero. This means that whenever it
is a divide function, it shows up as an error. I need it to count empty
cells as having no value, or to just ignore them, so that it does not affect
related formulas. Any help?
|