Checking Account Ledger Question

  • Thread starter Thread starter William Storey II
  • Start date Start date
W

William Storey II

Hello,
I have a checking account ledger made with excel, pretty simple ledger. My
question is this i have a column right before the amount column that says
reconciled (meaing that it has hit my statement online) the amount column i
enter it in either negative or positve and then i have a cell that says
Available balance this i got by just using the sum of the amount column, no
my question is this i am attempting to make a cell for my ledger balance i
need to figure out how to make it so that if the reconciled cell says no
then it will not be added to the sum.

Thank you for all of you help

William Storey II
 
William
A little hard to follow. Here is a general way to write an If formula
for something like what I think you want:
Say your reconciled cell is F1
If(F1="no",formula if No,formula if not no)
This says, in English, if F1 is "no" then use the first formula, if not, use
the second formula. HTH Otto
 
Back
Top