View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
miltdp
 
Posts: n/a
Default Can I get help with an excel 2003 formula

I have checkbook bal;ance in excel column A is Check #, Column B is check
amount, Column c is balance. Rather than go down the list of all the checks
listed but not written with the balance, how would I writed it so that if
there is no checks or deposits written to a check number then the correspond
d cell will be blank. The deposits are shown only when a check amount is
shown in b.

i.e. IF column "b" '='0 then "d" ='0