+ 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,593

    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

+ 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