Excel question - I'm sure its easy, please help
 

When I am multiplying stuff in column 1 and stuff in column 2 and having the product appear in column 3 is there anyway to keep column 3 blank if the returned value is going to be $0.00 ?

Thanks

bump for the excel wizards.

If you wish to
have a function return a blank value (not zero) to the cell, use quote marks without a space between them. Here’s an example:
=IF(E6>=Quota,E6*Comm_Rate,"")
This formula example calculates, or returns, a
commission value to the cell containing the formula if the test is true. If the test is false, it returns an empty string (a blank value) to that cell.

Hope this helps

Umm so I have to nest my =B12*C12 in a IF statement and put ,"") at the end? Thanks lol

Assuming the following:

A1 x B1 = C1

Enter this in C1: =IF(B1>0,A1*B1,"")

This is assuming that only column B could be 0.

Shit yea that did it. Thanks a million. And thank you too CBitch.

No prob sorry I didn't break it down more

No problem

1 more, lol. I have a running total column. I want it to be blank if the last line it added was blank or 0. On the first line it is only taking the figure from D12
=IF(D12>0,D12,"") and it works. it will show what is in D12 or it will be blank. But in the next box it will be what is in D12 + what is in D13 but if nothin is in D13 I want the cell blank (if its just going ot be D12's value again).

=IF(D13>0,D12+D13,"") gets an error.

If you have time here is a link to the file
http://www.naughty-coco.com/dan.xls
Thanks