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 ?
Bookmarks