+ Reply to Thread
Results 1 to 7 of 7

Cumulative Subtraction Until Total Met

  1. 04-05-2020, 07:01 AM #1
    agra64
    agra64 is offline
    Registered User
    Join Date
    04-04-2020
    Location
    paris, France
    MS-Off Ver
    ms office 2007
    Posts
    3

    Cumulative Subtraction Until Total Met

    Hi Guys
    I'm new to this forum and i need help for substract from total
    Attached is the problem
    Thank you very much for your help
    Agra
    Attached Files Attached Files
    Last edited by AliGW; 04-05-2020 at 08:19 AM.
    Reply With QuoteRegister To Reply
  2. 04-05-2020, 07:07 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Help for substract formula

    Welcome to the forum.

    When I know what's going on here, I'll improve your rather poor thread title, but I don't understand what you are trying to show us in the workbook. Please explain what you want to achieve.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-05-2020, 08:10 AM #3
    agra64
    agra64 is offline
    Registered User
    Join Date
    04-04-2020
    Location
    paris, France
    MS-Off Ver
    ms office 2007
    Posts
    3

    Re: Help for substract formula

    Basically i want a formula in which i can subtract everyday from the total. Now the total is changeable (lets say everyday you add certain amount to it) but the day 1 to day 6 are staying the same amount. I'll attach the new workbook.
    Thank you
    Attached Files Attached Files
    Last edited by AliGW; 04-05-2020 at 08:13 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 04-05-2020, 08:20 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Cumulative Subtraction Until Total Met

    I have now amended your thread title - please make sure you read the forum rules about thread titles and our other rules. Thanks.
    Reply With QuoteRegister To Reply
  5. 04-05-2020, 01:18 PM #5
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,292

    Re: Cumulative Subtraction Until Total Met 

    Please Login or Register  to view this content.
    Use this formula in E5
    Attached Files Attached Files
    Last edited by popipipo; 04-05-2020 at 01:32 PM. Reason: add file
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  6. 04-05-2020, 01:37 PM #6
    agra64
    agra64 is offline
    Registered User
    Join Date
    04-04-2020
    Location
    paris, France
    MS-Off Ver
    ms office 2007
    Posts
    3

    Re: Cumulative Subtraction Until Total Met

    Quote Originally Posted by popipipo View Post 
    Please Login or Register  to view this content.
    Use this formula in E5
    Thank you very much for your reply,
    but i need the formula for the whole row (F,G,H and I) day 3,4,5,6.
    So as i increase the total for lets say third time, the row in day 1 and 2 stay as are, only the day 3 gets the difference same for days 4,5,6,7 ect.
    Thank you again for your effort, hope i could explain properly my problem
    Reply With QuoteRegister To Reply
  7. 04-05-2020, 01:56 PM #7
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,292

    Re: Cumulative Subtraction Until Total Met

    If value stay fixed you need VBA
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add and Substract
    By Radheshyam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2018, 01:16 AM
  2. Add and Substract
    By Radheshyam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2018, 04:49 AM
  3. [SOLVED] substract value every nth row
    By watabe112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2018, 09:20 PM
  4. Formula to Substract if Conditions met in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2013, 11:07 PM
  5. Need formula in Excel to substract cell D from Cell C
    By Louise in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-25-2006, 01:55 PM
  6. [SOLVED] How do I substract numbers in range like this: Substract(a1..a10)
    By Paulo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-17-2005, 12:50 AM
  7. [SOLVED] how do I substract
    By kiserlouisa in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-23-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1