| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create account with regular income - How?
Hi
I have created a small spreadsheet for a post office account which has a regular income twice a week Is it possible to create a formula that will automatically input these amounts every week - and if so, how do I do it? Using Excel 2003 on Vista -- Martin ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create account with regular income - How?
Hi Martin
If you had weekly dates running down column A, and your amounts in column B and column C, you could use in B2 =IF($A2<=TODAY(),100,"") where 100 represents the income Do the same for C2 with the relevant amount for that column. Copy both formulae down for as many rows as you have dates in column A. When today's date exceeds or equals the weekly date, the amounts will appear. -- Regards Roger Govier "Martin ©¿©¬ @nohere.net" wrote in message ... Hi I have created a small spreadsheet for a post office account which has a regular income twice a week Is it possible to create a formula that will automatically input these amounts every week - and if so, how do I do it? Using Excel 2003 on Vista -- Martin ©¿©¬ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RE Create account with regular income - How?
On Tue, 5 Feb 2008 09:36:20 -0000, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote: Hi Martin If you had weekly dates running down column A, and your amounts in column B and column C, you could use in B2 =IF($A2<=TODAY(),100,"") where 100 represents the income Do the same for C2 with the relevant amount for that column. Copy both formulae down for as many rows as you have dates in column A. When today's date exceeds or equals the weekly date, the amounts will appear. Hi Roger, sorry for not replying sooner Your formula is very helpful, thank you But I can't figure out When today's date exceeds or equals the weekly date, the amounts will appear.< Can you tell me how to make that happen please -- Martin ©¿©¬ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RE Create account with regular income - How?
Hi Martin
Send me your workbook, and I will see if I can sort it out. Mail to roger at technology4u dot co dot uk Do the obvious with at and dot. -- Regards Roger Govier "Martin ©¿©¬ @nohere.net" wrote in message ... On Tue, 5 Feb 2008 09:36:20 -0000, "Roger Govier" <roger@technology4unospamdotcodotuk wrote: Hi Martin If you had weekly dates running down column A, and your amounts in column B and column C, you could use in B2 =IF($A2<=TODAY(),100,"") where 100 represents the income Do the same for C2 with the relevant amount for that column. Copy both formulae down for as many rows as you have dates in column A. When today's date exceeds or equals the weekly date, the amounts will appear. Hi Roger, sorry for not replying sooner Your formula is very helpful, thank you But I can't figure out When today's date exceeds or equals the weekly date, the amounts will appear.< Can you tell me how to make that happen please -- Martin ©¿©¬ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RE Create account with regular income - How?
On Thu, 7 Feb 2008 15:08:29 -0000, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote: Hi Martin Send me your workbook, and I will see if I can sort it out. Mail to roger at technology4u dot co dot uk Do the obvious with at and dot. Sent -- Regards Martin ©¿©¬ |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RE Create account with regular income - How?
Nothing arrived her.
Can you try again -- Regards Roger Govier "Martin ©¿©¬ @nohere.net" wrote in message ... On Thu, 7 Feb 2008 15:08:29 -0000, "Roger Govier" <roger@technology4unospamdotcodotuk wrote: Hi Martin Send me your workbook, and I will see if I can sort it out. Mail to roger at technology4u dot co dot uk Do the obvious with at and dot. Sent -- Regards Martin ©¿©¬ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a formula for a Chart of Account list? | Excel Worksheet Functions | |||
| how do i set up an income and expenditure account in excel? | Excel Worksheet Functions | |||
| Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
| formula for workbook showing daily income compared to goal income. | Excel Worksheet Functions | |||
| how do i create a daily income report (i'm a waitress) | New Users to Excel | |||
Hybrid Mode
