View Single Post
  #3   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?

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.