Results 1 to 2 of 2

Thread: Excel help

  1. #1
    Expert Forum User
    mhuigenbos's Avatar
    Join Date
    Dec 2008
    Location
    St Thomas
    Posts
    5,480
    Rep Power
    273

    Default Excel help

    I need a formula that automatically moves an amount from one cell to another depending on how overdue it is.

    Example:
    Column A: Debtor
    Column B: Project No
    Column C: Project Name
    Column D: Date
    Column E: Invoice amount
    Column F: Current
    Column G: 30 days
    Column H: 45 days
    Column I: 60+ days

    I need the amount to move to these rows when the date changes. Is this possible?

    Thank you

  2. #2
    New Member TylerL's Avatar
    Join Date
    Sep 2010
    Posts
    42
    Rep Power
    22

    Default

    Sorry about the delay, it took a little while to get a perfect answer ready for you. I was originally building the formula myself from scratch and then found this link on the Microsoft excel site.

    Hope it helps!

    Use conditional formulas in Excel to analyze financial data - Excel - Microsoft Office
    Tyler Logtenberg
    Network and Internet Marketing Consultant
    Claris Technologies

    Ask the Tech Expert
    http://forum.londonmoms.ca/ask-technology-expert/

Similar Threads

  1. Calling all Microsoft Excel Experts
    By InkyMama in forum Chit Chat
    Replies: 6
    Last Post: 09-27-2010, 07:48 PM
  2. Excel help! Quick!
    By punchanella in forum Chit Chat
    Replies: 10
    Last Post: 06-09-2010, 09:15 PM
  3. need excel help!
    By candies_61 in forum Chit Chat
    Replies: 2
    Last Post: 06-05-2009, 02:51 PM
  4. I need someone who knows excel well!!!
    By B&W'sMama in forum Chit Chat
    Replies: 8
    Last Post: 09-13-2008, 01:19 PM
  5. Finan, Excel, other swim schools?
    By mum_of_four in forum Chit Chat
    Replies: 1
    Last Post: 10-03-2007, 09:42 PM

Posting Permissions

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