Can the If function be used on blank cells?

  • Thread starter Thread starter oldsquid
  • Start date Start date
O

oldsquid

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
 
Forgot to say using Excel 2003...
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
 
Back
Top