+ Reply to Thread
Results 1 to 45 of 45

Hi i need some help for my assignment on savings/investments!!

Hybrid View

  1. #1
    Registered User
    Join Date
    08-19-2020
    Location
    london
    MS-Off Ver
    2016
    Posts
    27

    Re: Hi i need some help for my assignment on savings/investments!!

    this is for year 2020 for stocks balance. Im not sure if im right...
    Last edited by lwtoh001; 08-23-2020 at 03:57 AM.

  2. #2
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Hi i need some help for my assignment on savings/investments!!

    Quote Originally Posted by lwtoh001 View Post
    =IF(A10<B7,B2*(1+B6),B2+(D10*(1+B6))) this is for year 2020 for stocks balance. Im not sure if im right...
    Look at the numbers and get your calculator out. Does your spreadsheet give the right answer? If not your formula is wrong.

    B2 is the opening balance for your BANK not STOCKS...correct?
    Last edited by Croweater; 08-20-2020 at 04:22 AM.

+ 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. Depreciation Calculation for Multiple Investments
    By asifmian55 in forum Excel General
    Replies: 1
    Last Post: 01-18-2017, 12:31 PM
  2. Savings Assignment
    By cheggie in forum Excel General
    Replies: 3
    Last Post: 09-18-2007, 08:41 AM
  3. Using FV for investments
    By DANASHOKES in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2007, 01:28 AM
  4. How do I set up an Investments Trading and Cash Template?
    By Bambo Excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-10-2006, 02:45 AM
  5. need help charting a time progression for investments
    By Elwood in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-10-2006, 04:50 PM
  6. [SOLVED] INVESTMENTS OPPORTUNITES: Get 10.5% or 50% Monthly returns
    By Israel Fagbemi -- Top Rank Business Associates Gro in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 11-06-2005, 05:55 AM
  7. INVESTMENTS OPPORTUNITES: Get 10.5% or 50% Monthly returns
    By Israel Fagbemi -- Top Rank Business Associates Gro in forum Excel General
    Replies: 0
    Last Post: 11-06-2005, 05:50 AM

Tags for this Thread

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