+ Reply to Thread
Results 1 to 3 of 3

Calculate output for the logic in the attached spreadhseet based on user input

  1. #1
    Registered User
    Join Date
    10-28-2008
    Location
    US
    Posts
    11

    Calculate output for the logic in the attached spreadhseet based on user input

    I am struggling a lot with this solution. I have sunk hours into this and would appreciate any help.
    What I am trying to do is get the ROW 13 and ROW 18 outputs depending on inputs in ROW 2 to 5. Inputs in ROW 2 to 5 can have any value in any year. I would like to perform the calculations if the value in column U is 2 (if 1 then no action required)
    I don't need ROW 10, 11, 12 separately if that is easier ...I am interested in getting the ROW 13 basically.
    Anyone who can help PLEASE ?
    Attached Files Attached Files
    Last edited by tenn0228; 11-02-2009 at 10:05 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Calculate output for the logic in the attached spreadhseet based on user input

    tenn0228,

    If I understand you correctly:

    See the attached workbook "Calculate output for the logic - tenn0228 - SDG09.xls".

    Change the 'Description' in cells B10, and B15, to 'ABC'.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Registered User
    Join Date
    10-28-2008
    Location
    US
    Posts
    11

    Re: Calculate output for the logic in the attached spreadhseet based on user input

    The user can put his input in C2:S4. Based on that the ouput should change. I am trying to understand your solution but is it doing that ? Sorry if I am not understanding

+ Reply to Thread

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