Would if work?

J

just4ucreations

I am trying to figure out my expenses for the month. I want to be able that
once a bill is paid, and I note it in the spread sheet, it will come off the
total as for what is still due. I was using an if statement for it, which
worked fine in one sheet as all bills have been paid, but when I tried using
it in a different month sheet, it doesn't work out right. Hope this makes
sense.
 
J

just4ucreations

This is the formula I have:

=IF(G11:G16=1,E26-E11)

Which works just fine for one cell, but if I want a running total so I know
what is still needed to pay the bills, how do I do that?

Thanks
 
E

Eduardo

Sorry but the formula itself doesn't say what is in G11 or E26, E11, can you
send an example
 

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

Top