Split a number but the result should be always

[chadski021]

Is there a way to do this? The difference should be as close as possible. I use even number because the number are by pairs. 2 4 6 8 10

Example

18 =  10 and 8

20 =  10 and 10

22 = 12 and 10

36 = 18 and 14

 

 

 

[comment]

  On 10/9/2019 at 2:18 PM, chadski021 said:

36 = 18 and 14

Expand  

Why?

[chadski021]

because i cant split them 16 and 16 there both equal. Also if use 17 + 15 i will not work since the number are odd. So i move to 18 by 14.

 

[comment]

I am afraid I don't follow your logic. You split 20 into 10 and 10; they're equal and even. Why can't you split 36 into 18 and 18? They are also equal and even. OTOH, 18 + 14 = 32, not 36 - so this makes no sense to me at all.

 

[chadski021]

  On 10/9/2019 at 2:44 PM, comment said:

I am afraid I don't follow your logic. You split 20 into 10 and 10; they're equal and even. Why can't you split 36 into 18 and 18? They are also equal and even. OTOH, 18 + 14 = 32, not 36 - so this makes no sense to me at all.

 

Expand  

Sorry the 20 = 10 + 10 is wrong it should be 12 + 8. Basically we have to split it 60% / 40% something like that. the difference should be as close as 1 to 2 pairs.

Edited October 9, 2019 by chadski021

[comment]

  On 10/9/2019 at 2:54 PM, chadski021 said:

something like that

Expand  

I am afraid that's not a good enough description. You are asking how to do something, but we don't know exactly what that something is. Maybe you should start by explaining why this is needed.

 

ADDED:

Maybe something like this could work for you::

Let ( [
a = 2 * Ceiling ( number / 4 ) ;
b = 2 * Floor ( number / 4 ) 
] ;
If ( a = b ; List ( a + 2 ; b - 2 ) ; List ( a ; b ) )
)

This returns:

18 = 10 + 8;
20 = 12 + 8;
22 = 12 + 10;
36 = 20 + 16.

 

Edited October 9, 2019 by comment

[chadski021]

  On 10/9/2019 at 3:07 PM, comment said:

I am afraid that's not a good enough description. You are asking how to do something, but we don't know exactly what that something is. Maybe you should start by explaining why this is needed.

 

Expand  

Ok, I try my best to explain this. We have a database called shutter. Shutter is installed to window/door and has blades by pairs. ex 20 = 10 pairs. We have scenario that a sliding door has 2 panels. 50% 1 panel can slide and 50% 1 cannot slide. Basically we install the shutter always 50% by 50% if the middle window is open and lock reachable in the middle. But in this case 50% of slide cant be open, So i need to increase at 1 to 2 pairs of blade so its still able to lock it inside. attached is my sample idea

[comment]

Okay, then I think my suggestion above should work for you. If you like, you can split the calculation to two fields:

2 * Ceiling ( Number / 4 ) + 2 * not Mod ( Number ; 4 )

and:

2 * Floor ( Number / 4 ) - 2 * not Mod ( Number ; 4 )

 

[chadski021]

thanks @comment it works what a relief. Also What if the difference is 3 to 4 pairs?

Edited October 9, 2019 by chadski021

[comment]

  On 10/9/2019 at 4:09 PM, chadski021 said:

Also that if the difference is 3 to 4 pairs?

Expand  

Sorry, not sure what you mean by that.

[chadski021]

  On 10/9/2019 at 4:24 PM, comment said:

Sorry, not sure what you mean by that.

Expand  

something like 

20 = 16 and 4

30 = 18 and 12

[comment]

Wouldn't it be just a matter of adding/subtracting 2 to the results of the above?

[chadski021]

  On 10/9/2019 at 4:57 PM, comment said:

Wouldn't it be just a matter of adding/subtracting 2 to the results of the above?

Expand  

Got it thank you so much.