Blank Cells

[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

 

[Pete_UK]

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

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

Copy down as required.

Hope this helps.

Pete

 

[FSt1]

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

regards
FSt1

 

[Bob Phillips]

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)