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
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 helpsICQ-46523581Comment
-
Originally posted by CBytch
Umm so I have to nest my =B12*C12 in a IF statement and put ,"") at the end? Thanks lolComment
-
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.Comment
-
Originally posted by P. Nash
Shit yea that did it. Thanks a million. And thank you too CBitch.Comment
-
No prob sorry I didn't break it down moreICQ-46523581Comment
-
-
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
ThanksComment
Signature For Sale
Comment