I have Cells A1, B1, & C1. I want C1 to display the total of A1+B1. Cell C1 is to be blank until numbers are entered. If I enter "0" in A1, THEN C1 will display a zero.
If I only place a zero in B1, THEN C1 will display a zero. I cannot wrap my head around the syntax of blanks and zeros. I know it sounds easy, but it is killing me!
Try this in C1:
=IF(AND(A1>0,B1>0),A1+B1,"")
Hope this helps.
Pete
How about this?
=IF(A1+B1>0,A1+B1,"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ford,
one of the cells could still be blank and you would get a result.
Pete
@ Pete
hmm true
maybe...
=IF(countif(A1:B1,0)>1,A1+B1,"")
Note that in Excel 0 > [space] > =""
If somehow A1 or B1 takes on one of the second two values (a space or empty string), any formula involving >0 will not work. Just to pile on, here's my suggestion: =IF(AND(ISNUMBER(A1),ISNUMBER(B1)),SUM(A1:B1),"")
Re: Blank Cells & Zeros
It doesn't work. I've tried them all.
Maybe..
=IF(COUNT(A1:B1),IF(A1="",B1,SUM(A1:B1)*(A1<>0)),"")
Life's a spreadsheet, Excel!
Say thanks, Click *
OK long way around...
=if(or(A1=0,A1="",B1=0,B1=""),"",A1+B1)
I want C1 to display the total of A1+B1. Cell C1 is to be blank until numbers are entered. If I enter "0" in A1, THEN C1 will display a zero.
If I only place a zero in B1, THEN C1 will display a zero.
I find the wording confusing but maybe this will work for you.
If a 0 is entered in either A1 or B1 and the other cell is blank, the result will be blank. If a number other than 0 is entered in either A1 or B1, C1 return that number. If a number other than 0 is entered and a value not a number is entered into the other cell, C1 will be blank.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
"If a 0 is entered in either A1 or B1 and the other cell is blank, the result will be blank." <- This is NOT what I want; the result should be zero.
change mine to this...
=if(or(A1=0,A1="",B1=0,B1=""),0,A1+B1)
=if(count(a1:b1),a1+b1,"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
=if(count(a1:b1),SUM(a1:b1),"")
=if(or(and(A1=0,A1=""),and(B1=0,B1="")),0,A1+B1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks