+ Reply to Thread
Results 1 to 2 of 2

Splitt number in a cell into 2 different cells when it exceeds a particular number

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    Venlo, Netherlands
    MS-Off Ver
    ms 2010
    Posts
    1

    Question Splitt number in a cell into 2 different cells when it exceeds a particular number

    I want to know if its possible to split a cell value into 2 other values when it exceeds a particular number.

    Example : When Cell A1= 6 than -----> Cell A2: 6 Cell A3:0 because Cell A1 doesn't exceed the number 6

    When Cell A1=8 than ------> Cell A2: 6 Cell A3: 2 because Cell A1 is exceeded by 2 in want 2 to be in cell A3 and 6 to be in A2


    is there a formula or something like that to create the example above ?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,921

    Re: Splitt number in a cell into 2 different cells when it exceeds a particular number

    how do you define the number
    lets say its in B1 you have the defined number ie 6 or 8
    Then IN
    A2 = =IF(A1>=$B1,$B1,$A1)
    A3 = =IF(A1<=B1,0,A1-B1)
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] Round number down if exceeds x
    By Excelnoob124 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-17-2020, 12:23 PM
  2. Replies: 6
    Last Post: 06-03-2018, 07:57 PM
  3. [SOLVED] Pop-up message if value for sum of cells exceeds a predefined number
    By dLhx in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-24-2018, 10:58 PM
  4. [SOLVED] keep the cell the same unless it exceeds a predetermined number then change cell
    By Spyderwoman in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2017, 03:26 PM
  5. [SOLVED] Determine whether number of positive numbers exceeds number of negative numbers
    By HRBP in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-04-2012, 09:49 PM
  6. Replies: 0
    Last Post: 01-19-2012, 02:55 PM
  7. [SOLVED] counting if a value exceeds a specified number
    By Albert in forum Excel General
    Replies: 2
    Last Post: 07-20-2006, 09:20 AM

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