"IF" help
 

Here is a brief and thrown together explanation of what I want:

In cell A7 I want SUM(A1:A6)IF(SUM(A1:A6<0) AND IF(SUM(A1:A6=0)Leave Blank
In cell A8 I want IF(A7=63)Then 35, ELSE Leave Blank


Here is what I am currently using.

In cell A7
=IF(SUM(A1:A6)<0,SUM(A1:A6),"")
In cell A8
=IF(A7=63,35,"")

It works, however the when A7 is blank, A8 displays 35 instead of being
blank. I tried using SUMIF in A7 but when the sum of A1:A6 was 0 the cell
displayed a 0 instead of being blank.

Thanks in advance for any help.

Brandon

"IF" help
 

A7 isn't blank, it has a formula whose result is a string, of zero length.
A string is regarded as greater than any number, so the formula =""63
returns TRUE, hence A8 shows 35.
Perhaps you want to change A8 to say =IF(A7="","",IF(A7=63,35,""))
--
David Biddulph

"Brandon" wrote in message
...
Here is a brief and thrown together explanation of what I want:

In cell A7 I want SUM(A1:A6)IF(SUM(A1:A6<0) AND IF(SUM(A1:A6=0)Leave
Blank
In cell A8 I want IF(A7=63)Then 35, ELSE Leave Blank


Here is what I am currently using.

In cell A7
=IF(SUM(A1:A6)<0,SUM(A1:A6),"")
In cell A8
=IF(A7=63,35,"")

It works, however the when A7 is blank, A8 displays 35 instead of being
blank. I tried using SUMIF in A7 but when the sum of A1:A6 was 0 the cell
displayed a 0 instead of being blank.

Thanks in advance for any help.

Brandon

"IF" help
 

in cell A8:
=IF(A7="","",IF(A7=63,35,""))
--
hope to help,
cm


"Brandon" wrote:

Here is a brief and thrown together explanation of what I want:

In cell A7 I want SUM(A1:A6)IF(SUM(A1:A6<0) AND IF(SUM(A1:A6=0)Leave Blank
In cell A8 I want IF(A7=63)Then 35, ELSE Leave Blank


Here is what I am currently using.

In cell A7
=IF(SUM(A1:A6)<0,SUM(A1:A6),"")
In cell A8
=IF(A7=63,35,"")

It works, however the when A7 is blank, A8 displays 35 instead of being
blank. I tried using SUMIF in A7 but when the sum of A1:A6 was 0 the cell
displayed a 0 instead of being blank.

Thanks in advance for any help.

Brandon

"IF" help
 

Perfect, thank you.

"David Biddulph" wrote:

A7 isn't blank, it has a formula whose result is a string, of zero length.
A string is regarded as greater than any number, so the formula =""63
returns TRUE, hence A8 shows 35.
Perhaps you want to change A8 to say =IF(A7="","",IF(A7=63,35,""))
--
David Biddulph

"Brandon" wrote in message
...
Here is a brief and thrown together explanation of what I want:

In cell A7 I want SUM(A1:A6)IF(SUM(A1:A6<0) AND IF(SUM(A1:A6=0)Leave
Blank
In cell A8 I want IF(A7=63)Then 35, ELSE Leave Blank


Here is what I am currently using.

In cell A7
=IF(SUM(A1:A6)<0,SUM(A1:A6),"")
In cell A8
=IF(A7=63,35,"")

It works, however the when A7 is blank, A8 displays 35 instead of being
blank. I tried using SUMIF in A7 but when the sum of A1:A6 was 0 the cell
displayed a 0 instead of being blank.

Thanks in advance for any help.

Brandon