Return values (between and above a value) to other cells

[johnjohn]

Greetings to all! In libre calc which is like Excel I am looking for a command that will return results to other cells (the result if between and remaining part over, if any) .

For example: IF value in cell H5 is between 1600 and 2000 (or over 2000), remove the value between and transfer it to cell H11, while if any value over 2000, transfer it to cell H12.

In other words:

If value in H5 is <1600 show that value in H10, show 0 to H11, show 0 to H12.
If value in H5 is >1600≤2000 show 1600 in H10, show value between in H11, show 0 in H12
If value in H5 is >2000 show 1600 in H10, show 400 in H11, show remaining in H12

Any ideas ?

[JohnSUN]

Welcome! Yes, most of this can be done with simple formulas. But this requirement confuses me:

@johnjohn

remove the value between

Formulas

H10 - =MIN(H5;1600)

H11 - =MIN(MAX(H5-1600;0);400)

H12 - =MAX(H5-2000;0)