+ Reply to Thread
Results 1 to 3 of 3

Need help: Ruingn formula until row sum hits a maximum

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need help: Ruingn formula until row sum hits a maximum

    Hi Everyone - I am hoping you can give me some help with this as I am STUMPED. Here is what I need:

    Row 3 Calculates Pension contributions with this formula "=(C3-(134.62*2))*4.95%" That formula goes across for the year, and is totaled in column L.

    I need L3 to either hit a Maximum number of 2356.2 or total the sum if it's less than this. I've tried some formulas but gotten into a circular reference number.

    I also am having trouble returning the last "remainder" value. Can you help me without the use of a helper row or column?

    Any help is greatly appreciated,
    Sandi

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Need help: Ruingn formula until row sum hits a maximum

    Can you post a sample workbook that exhibits the kind of calculations you want to do?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    08-27-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need help: Ruingn formula until row sum hits a maximum

    Hi Ron,

    Thanks for the quick reply! Please see the attached sample workbook.

    Let me know if I can provide any further clarification.

    I really appreciate your help!

    Sandi

    Edit: I need the formula in row 8 to continue until the sum of E8:M8 & P8:R8 (CPP contributions for calendar year 2013) is equal to the value in B1 = $2356.20 (instead of H1).
    Attached Files Attached Files
    Last edited by sandik; 08-27-2013 at 09:51 PM.

+ 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] EXCEL Formula to show howmany hits when checking list against data?
    By sem in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-14-2012, 10:14 PM
  2. Replies: 7
    Last Post: 11-02-2011, 08:22 PM
  3. Replies: 2
    Last Post: 08-07-2011, 03:49 PM
  4. hyperlink to hits from excel formula
    By pinkstonm in forum Excel General
    Replies: 0
    Last Post: 06-06-2011, 01:47 PM
  5. oh well you've got to try enough hits and you're rich
    By martindwilson in forum The Water Cooler
    Replies: 11
    Last Post: 03-04-2010, 11:12 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