+ Reply to Thread
Results 1 to 2 of 2

Formula to spill value to another cell after reaching a specific amount.

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Formula to spill value to another cell after reaching a specific amount.

    Hi... can anyone help me figure this one out?

    If I want a value in one cell to only go to 48 and anything accumulated after that amount be added to another cell.... is there a formula I can use?

    Eg: B4 is at 50, but I want it only to read 48 and add the 2 to A4.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,589

    Re: Formula to spill value to another cell after reaching a specific amount.

    Something like this?
    A1=50
    A2=MIN(A1,48)
    A3=A1-A2
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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. Formula to add specific amount of years to a date
    By WinterTom in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-23-2021, 11:57 PM
  2. Formula/function that counts amount of rows between specific number.
    By angelitovs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2012, 09:29 PM
  3. [SOLVED] Is it possible to create a macro that repeats for the cell below till reaching a blank cel
    By CDNcameron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 06:07 PM
  4. Replies: 5
    Last Post: 09-30-2010, 08:02 PM
  5. allowing larger font charactrers to "spill over" into the cell above
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2010, 02:00 PM

Tags for this Thread

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