| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Would if work?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Would if work?
hi,
please send your formula "just4ucreations" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Would if work?
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 "Eduardo" wrote: hi, please send your formula "just4ucreations" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Would if work?
Sorry but the formula itself doesn't say what is in G11 or E26, E11, can you
send an example "just4ucreations" wrote: 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 "Eduardo" wrote: hi, please send your formula "just4ucreations" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Linear Mode
