|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
09-22-2006, 11:21 AM
|
#1 |
|
Confirmed User
Join Date: Nov 2003
Location: 237 619 975
Posts: 8,944
|
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
__________________
|
|
|
|
09-22-2006, 11:22 AM
|
#2 |
|
PostMaster General
Join Date: Aug 2006
Posts: 10,781
|
bump for the excel wizards.
__________________
|
|
|
|
|
09-22-2006, 11:26 AM
|
#3 |
|
Confirmed User
Join Date: Apr 2004
Location: Toronto
Posts: 257
|
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
__________________
ICQ-46523581 |
|
|
|
|
09-22-2006, 11:32 AM
|
#4 | |
|
Confirmed User
Join Date: Nov 2003
Location: 237 619 975
Posts: 8,944
|
Quote:
Umm so I have to nest my =B12*C12 in a IF statement and put ,"") at the end? Thanks lol
__________________
|
|
|
|
|
|
09-22-2006, 11:33 AM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Feb 2004
Location: Scottsdale
Posts: 305
|
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. |
|
|
|
|
09-22-2006, 11:36 AM
|
#6 | |
|
Confirmed User
Join Date: Nov 2003
Location: 237 619 975
Posts: 8,944
|
Quote:
Shit yea that did it. Thanks a million. And thank you too CBitch.
__________________
|
|
|
|
|
|
09-22-2006, 11:37 AM
|
#7 |
|
Confirmed User
Join Date: Apr 2004
Location: Toronto
Posts: 257
|
No prob sorry I didn't break it down more
__________________
ICQ-46523581 |
|
|
|
|
09-22-2006, 11:39 AM
|
#8 |
|
Confirmed User
Industry Role:
Join Date: Feb 2004
Location: Scottsdale
Posts: 305
|
No problem
|
|
|
|
|
09-22-2006, 11:50 AM
|
#9 |
|
Confirmed User
Join Date: Nov 2003
Location: 237 619 975
Posts: 8,944
|
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
__________________
|
|
|
|
Signature For Sale