+ Reply to Thread
Results 1 to 2 of 2

Need help with an ROI Calculator

  1. #1
    Registered User
    Join Date
    05-13-2020
    Location
    Nottingham
    MS-Off Ver
    10
    Posts
    1

    Need help with an ROI Calculator

    I've created a basic ROI calculator but wish to add a variable input which delays the return on investment impact until training and other services are up and running

    I need to know what formula I should use to delay the benefit starting from month 1 (as it does currently) and start it using the cell input for the number of months to delay beginning the benefit

    Is there anyone out there that can help?

    So if ('VERICUT ROI Calculator'!C18) = 2 then the CGTech Savings (all rows from b7 to b12 move to D7 to D12 i.e. begin in Month 3 rather than 1 as it does now)
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Need help with an ROI Calculator

    It would be different for each row, but something like this in B7:
    =IF(COLUMN()-1<='VERICUT ROI Calculator'!$C$18,0,IF(COLUMN()-2='VERICUT ROI Calculator'!$C$18,'VERICUT ROI Calculator'!$C$10,A7+'VERICUT ROI Calculator'!$C$10))
    Then you could drag that to the right.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. [SOLVED] Help with my Calculator
    By rham243 in forum Excel General
    Replies: 4
    Last Post: 07-30-2015, 01:15 PM
  2. % APR Calculator
    By tonicdesigns in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2014, 07:59 AM
  3. Tax Calculator
    By excel-lent T in forum Excel General
    Replies: 2
    Last Post: 07-27-2010, 02:34 PM
  4. Tax Calculator
    By jpxet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2008, 08:26 PM
  5. Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM
  6. uk tax calculator
    By DarkNight in forum Excel - New Users/Basics
    Replies: 21
    Last Post: 05-03-2006, 01:25 PM
  7. calculator
    By Colin2u in forum Excel General
    Replies: 5
    Last Post: 08-19-2005, 04:13 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