Thread: Blank Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mario[_2_] Mario[_2_] is offline
external usenet poster
 
Posts: 2
Default 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