Results 1 to 3 of 3

Multiple independant variables in cost estimate

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Multiple independant variables in cost estimate

    All,

    I am working on a cost estimate and I am having trouble with some equations in my master template. I need to format the spread sheet, so that "Deployed Units" change automatically, when the following variables are changed: FY date, units deployed, and life cycle expectancy (years).

    I have attached a simplified dummy book to show the results I want (highlighted in red), when I change the variables (highlighted in yellow). Please do not worry about "FY" row formatting, just the outcome of the correct deployed units.

    Sorry for the ambiguous title, I wasn't sure what else to out

    Thank you for your help in advance, this forum has always been extremely helpful!
    Attached Files Attached Files
    Last edited by wmfinance; 07-28-2010 at 09:06 AM.

Thread Information

Users Browsing this Thread

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

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