1
   

How add Excel cells ONLY when a integer is present?

 
 
Reply Thu 30 Sep, 2004 01:53 pm
How can I add values in Excel cells only when there is a value present? If there is no integer in the cell I want ADD to ignore the cell.
So far my formulas are assuming a zero is present and using this zero cell to affect other calculations in my spreadsheet.
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 351 • Replies: 2
No top replies

 
roger
 
  1  
Reply Thu 30 Sep, 2004 03:11 pm
What is the zero interfering with - something like the Count function.

Well maybe this, if I get the syntax right, working from memory:

=if(A1=0, " ", A1)

Just try putting this formula into the cell you want to be blank instead of zero. A1 would be the cell from which the value comes. Haven't tested this, and not sure it addresses your question, but give it a shot. The space between the two quotation marks will return a blank.

If this doesn't do what you want, you might check out some of the advanced cell formatting options.
0 Replies
 
jespah
 
  1  
Reply Fri 1 Oct, 2004 08:19 am
If I remember correctly, you can do a countif statement and have the positive condition be something like "is not null" or perhaps the negative condition be ="" (note that that's two double quotes with nothing between them - the definition of null. If it is not a true null that you want to get rid of, and rather a 0, the negative condition would instead be ="0"
0 Replies
 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » How add Excel cells ONLY when a integer is present?
Copyright © 2025 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.05 seconds on 07/23/2025 at 04:21:29