Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Programming a simple formula
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 |
#2
|
|||
|
|||
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. In article , anagaraj1 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Help - Simple Formula ! | Excel Discussion (Misc queries) | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |