M
Mario
I J K
Price Tax Total
21 $100 $10.00 $110.00
22
23
J21 calculates & displys the tax (10%)
K21 displays the sum of I & J
My formula in Tax column J21 is =sum(I21*0.1)
My formula in Total column K21 is =sum(I21:J21)
If no price is put into I21, I get the zero $ values.
If I21 is blank, how do I make J & K blank also?
I J K
Price Tax Total
21 $0.00 $0.00
22
23
TIA
Mario
Price Tax Total
21 $100 $10.00 $110.00
22
23
J21 calculates & displys the tax (10%)
K21 displays the sum of I & J
My formula in Tax column J21 is =sum(I21*0.1)
My formula in Total column K21 is =sum(I21:J21)
If no price is put into I21, I get the zero $ values.
If I21 is blank, how do I make J & K blank also?
I J K
Price Tax Total
21 $0.00 $0.00
22
23
TIA
Mario