I'm making a worksheet so that when data has been entered it will automatically calculate the tax, however right now it shows it as $0.12.
So basically right now I have one cell waiting for data and another cell with the formula =product(i2,0.12), this cell will show the answer as being 0.12, how do I make it a zero until data has been entered?
Multiply a cell with a number but when there is no data show a zero
-
-
Re: Multiply a cell with a number but when there is no data show a zero
Just use:
=I2 * 0.12
-
Re: Multiply a cell with a number but when there is no data show a zero
Well I feel dumb
Thank you! -
Re: Multiply a cell with a number but when there is no data show a zero
Naa, don't feel dumb
The PRODUCT function ignores blank values, which in multiplication speak means multiply by 1...the times operator "*" counts blank cells as zero. That's why the difference in answers.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!