Can the If function be used on blank cells?
 

I am trying to get the If function to work in this worksheet, but it does
like me...
A B C
1 Purch. Paid Bal
2
3 $0.15 -$0.03
4 $73.10 $73.07
5 $29.70 $102.77
6 $102.77
7 $102.77


in the "C" column I would like to have a conditional "IF" A6 is blank and B6
is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and
below will be blank.

Thanks,
Bill
--
Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.

Can the If function be used on blank cells?
 

One way:

C6: =IF(COUNT(A6:B6)=0,"",C5-A6+B6)

In article ,
"oldsquid" wrote:

I am trying to get the If function to work in this worksheet, but it does
like me...
A B C
1 Purch. Paid Bal
2
3 $0.15 -$0.03
4 $73.10 $73.07
5 $29.70 $102.77
6 $102.77
7 $102.77


in the "C" column I would like to have a conditional "IF" A6 is blank and B6
is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and
below will be blank.

Thanks,
Bill

Can the If function be used on blank cells?
 

Forgot to say using Excel 2003...
"oldsquid" wrote in message ...
I am trying to get the If function to work in this worksheet, but it does
like me...
A B C
1 Purch. Paid Bal
2
3 $0.15 -$0.03
4 $73.10 $73.07
5 $29.70 $102.77
6 $102.77
7 $102.77


in the "C" column I would like to have a conditional "IF" A6 is blank and B6
is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and
below will be blank.

Thanks,
Bill
--
Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.

Can the If function be used on blank cells?
 

Thanks! Works like a charm...
"JE McGimpsey" wrote in message ...
One way:

C6: =IF(COUNT(A6:B6)=0,"",C5-A6+B6)

In article ,
"oldsquid" wrote:

I am trying to get the If function to work in this worksheet, but it does
like me...
A B C
1 Purch. Paid Bal
2
3 $0.15 -$0.03
4 $73.10 $73.07
5 $29.70 $102.77
6 $102.77
7 $102.77


in the "C" column I would like to have a conditional "IF" A6 is blank and B6
is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and
below will be blank.

Thanks,
Bill