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 ?
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)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks