Can the If function be used on blank cells?

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
 
O

oldsquid

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
 

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

Similar Threads

Data Entry - Write to next cell & next blank line 0
conditional formatting based on different cells with more conditio 1
returning blank cells in an IF function 1
Can I use sumif with OR to sum based on two column criteria? 2
IF function with too many arguments 3
Re-post Standard Deviation 3
Nested formula...I think 1
Need help to match 1

Top