Blank Cells
 

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

Blank Cells
 

In J21: =IF(I21="","",I21*0.1)

K21: =IF(J21="","",I21+J21)

Copy down as required.

Hope this helps.

Pete

On Jan 10, 10:18*am, "Mario" wrote:
* * * * * * * 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

Blank Cells
 

hi
in j column put this.....
=IF(I2="","",I2*0.1)
in k column put this...
=IF(I2="","",SUM(I2:J2))

regards
FSt1


"Mario" wrote:

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

Blank Cells
 

J21: =IF(I21="","",I21*0.1)

K21: =IF(I21="","",SUM(I21:J21))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mario" wrote in message
...
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