+ Reply to Thread
Results 1 to 8 of 8

Formula that allows me to stop deductions from another cell when reach a max value

  1. #1
    Registered User
    Join Date
    05-16-2017
    Location
    London, england
    MS-Off Ver
    office 365 2016
    Posts
    7

    Question Formula that allows me to stop deductions from another cell when reach a max value

    please find the sample attached.
    Thanks guys
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by RubenC; 05-16-2017 at 05:40 AM. Reason: Adding a sample

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    It would help if you attached a sample Excel workbook, so that we can see what formulae you are using at present.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Pete

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    Which formulas and what cells that formulars are in?
    Quang PT

  4. #4
    Registered User
    Join Date
    05-16-2017
    Location
    London, england
    MS-Off Ver
    office 365 2016
    Posts
    7

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    sample as been attached thanks !

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    See attached:

    in A2

    =MIN(SUM($C$2:C2),400)

    Copy down

    in C2

    =B2*0.04 (fixed)

    in C3

    =IF($A2+($B3*0.04)>400,400-$A2,$B3*0.04)

    copy down

    in D2

    =$B2-$C2
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-16-2017
    Location
    London, england
    MS-Off Ver
    office 365 2016
    Posts
    7

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    Many thanks !

    You are a star

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    And thank you for the rep.

  8. #8
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Formula that allows me to stop deductions from another cell when reach a max value

    Thanks for the rep from me, as well, though I didn't do very much.

    The reason I asked you to attach a sample workbook is that your image does not show which columns and rows the data is in, and we can't work with a picture anyway - we would have to make assumptions about where your data is located, AND type the data into a workbook before we could start to play about with some formulae (which many contributors are reluctant to do, given that you already have an Excel file from which you took the image). For future reference, you will tend to get a quicker answer (and a more accurate one) if you attach a sample Excel file, rather than a picture of one.

    Pete

+ 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. payment formula based on the deductions.
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-07-2014, 12:27 PM
  2. Formula to show deductions and balance
    By Rpatel1974 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2014, 02:15 PM
  3. Formula to work out deductions based on hours and time
    By elmobram22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2013, 12:13 PM
  4. How to stop updating cells after you reach a certain number
    By dberg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2013, 05:01 PM
  5. [SOLVED] Help Calculating Deductions In A Single Cell
    By nevintech in forum Excel General
    Replies: 2
    Last Post: 08-13-2012, 04:15 PM
  6. Formula to work out UK Tax deductions?
    By Sepia in forum Excel General
    Replies: 2
    Last Post: 01-11-2008, 09:00 AM
  7. How do I setup a formula for payroll deductions in excel
    By Skeeter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2005, 06:06 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