View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oldsquid oldsquid is offline
external usenet poster
 
Posts: 13
Default 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