Programming a simple formula

[anagaraj1]

Hi all,

I am trying to program a simple formula where I can input a number i
one cell, multiply it by a number in another cell in the next column
multiply these 2 numbers by 1.5, and then display the product in th
third column.

My problem is that if I leave the cells in the first two columns blank
the number 1.5 is displayed in the third column. I want the thir
column to be blank if I leave the first two columns blank. Do you kno
what I might be doing wrong?


Thanks,
Aru

 

[JE McGimpsey]

One way:

=IF(COUNT(A1:B1)>0,A1*B1*1.5,"")

This actually leaves a null string ("") as the result, rather than being
truly blank, but you can't have a cell both blank and containing a
formula.