"IF" help

[Brandon]

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

 

[David Biddulph]

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,""))

 

[cm]

in cell A8:
=IF(A7="","",IF(A7>=63,35,""))

 

[Brandon]

Perfect, thank you.

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,""))