Formula to control resulte by length

With this formula que can create partes by a interval of main parte lenght

For example:
For a wall with X lenght we apply X number of Props

So:
Apply 1 prop for a wall less or equal than 1 meter length
Apply 2 prop for a wall bigger than 1 meter length and less or equal than 2.4
Apply 3 prop for a wall bigger than 2.4 meter length and less or equal than 3.8
Apply 4 prop for a wall bigger than 3.8 meter length and less or equal than 5.3
Apply 5 prop for a wall bigger than 5.3 meter length and less or equal than 6.8
Apply 6 prop for a wall bigger than 6.8 meter

Simplify
1 Prop until 1000mm
2 Props until 2400mm
3 Props until 3800mm
4 Props until 5300mm
5 Props until 6800mm
6 Props bigger 6800mm

=if(D10<=1000) then 1 else if (D10>1000 && D10<=2400) then 2 else if (D10>2400 && D10<=3800) then 3 else if (D10>3800 && D10<=5300) then 4 else 5  endif endif endif endif