+ Reply to Thread
Results 1 to 11 of 11

help keep track of my family's finances,

  1. #1
    Registered User
    Join Date
    07-18-2018
    Location
    America
    MS-Off Ver
    Microsoft Office Home and Student 2016
    Posts
    2

    help keep track of my family's finances,

    Okay, so I'm going to try to sum this up as best as I can:
    I am trying to make a spreadsheet to better keep track of my family's finances, and I ran into an issue that completely stumped me.
    Basically, I have a cell for a line of credit (we'll call it A1) and a cell for a checking account(A2). I would like for A1's max value to be $500 and any excess to roll over into A2. I'm not sure it can be done, but if it can, how would I go about making this happen?
    Last edited by FDibbins; 07-18-2018 at 11:06 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help keep track of my family's finances,

    Hi, welcome to the forum

    1. I have changed your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    2. You cannot have an entry (value. text etc) in a cell AND a formula.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: help keep track of my family's finances,

    like this?

    578
    user input
    78
    =IF(A1>500,A1-500,0)


    or I missed something...
    Last edited by sandy666; 07-18-2018 at 11:19 PM.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help keep track of my family's finances,

    sandy, depending on where A1 comes from, that may be a very good idea (but not if it is manually entered, which was my thought)

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: help keep track of my family's finances,

    Hi Ford,
    I think I don't understand

    what is the difference between value from formula or manually entered into A1?

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help keep track of my family's finances,

    If OP manually enters $600 into A1, they want 100 transferred to A2

    (at least, thats how I read it, but I have been wrong before)

  7. #7
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: help keep track of my family's finances,

    I think I got it
    if OP enter 600 to A1
    100 will be transfered to A2
    and in A1 should stay 500 ?

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help keep track of my family's finances,

    Yes, something like that.

  9. #9
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: help keep track of my family's finances,

    Yep, so VBA

    But IMHO, this is not a facilitation but rather a difficulty because OP will not know the total income but only the current value from the addition of A1 and A2. Unless somehow the next values in A2 will also be added up. But for me it does not make any sense.
    Or OP did not say "the whole truth" as he has an organized financial sheet

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: help keep track of my family's finances,

    Eg.
    First entry A1: 510 => A1 = 500, A2 = 10
    Second entry A1: 520 => A1 = 500, A2 = 30
    Third entry A1: 530 => A1 = 500, A2 = 60
    A1 result = 500
    A2 result = 60
    Total: 560 so where is 1000 ?!

    unless subsequent amounts entered into A1 are also added up

    complicated

    1,048,576 rows by 16,384 columns and OP wants everything in two cells
    Last edited by sandy666; 07-19-2018 at 01:03 AM.

  11. #11
    Registered User
    Join Date
    07-18-2018
    Location
    America
    MS-Off Ver
    Microsoft Office Home and Student 2016
    Posts
    2
    Quote Originally Posted by sandy666 View Post
    Yep, so VBA

    But IMHO, this is not a facilitation but rather a difficulty because OP will not know the total income but only the current value from the addition of A1 and A2. Unless somehow the next values in A2 will also be added up. But for me it does not make any sense.
    Or OP did not say "the whole truth" as he has an organized financial sheet
    Its mostly organized. Though this one thing is giving me a huge headache. Im going to try all the suggestions made in this thread tomorrow afternoon.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with a financial formula
    By RasmusEU in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-01-2017, 07:18 AM
  2. Need help with a financial formula
    By SargeUSMC in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-16-2012, 01:54 PM
  3. Replies: 1
    Last Post: 03-04-2012, 02:37 AM
  4. Excel 2007 : Financial Formula
    By mdkimble81 in forum Excel General
    Replies: 1
    Last Post: 10-03-2011, 06:45 PM
  5. Financial Formula help
    By maro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2010, 01:30 AM
  6. Financial Formula
    By scubab in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2007, 09:31 AM
  7. Financial Stmt rounding issues
    By Jeanne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2006, 01:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1