Hi all,
I am trying to program a simple formula where I can input a number in
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 the
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 third
column to be blank if I leave the first two columns blank. Do you know
what I might be doing wrong?
Thanks,
Arun
--
anagaraj1
------------------------------------------------------------------------
anagaraj1's Profile:
http://www.excelforum.com/member.php...o&userid=25827
View this thread:
http://www.excelforum.com/showthread...hreadid=392891