"IF" help

B

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
 
D

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

Brandon

Perfect, thank you.

David Biddulph said:
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,""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top