Help with Formulas

Hi there,

I've watched a bunch of tutorials and read the transversal logic operators. But I'm pretty new to formula creation and hoping someone can help me.

I'm looking to create a formula for lighting track components. It essentially comes in 3ft (1M) and 6ft (2M) sections (sometimes in 9ft - 3M sections) and then has components like feeds and joiners. For the track itself, I got somewhere with a series of conditions "if the track is under 3ft, use a 1M track" "if it's between 3 and 6 ft use a 2M track" "if it's between 6ft and 9ft use a 2M + a 1M track" etc etc. I'm wondering if there's a way to write simpler logic so I don't have to write a formula for every size possibility up to 100+ ft. Is there a formula that would say "for every 6ft use a 2M track and if the remainder is greater than 3ft add a 1M track"?

Thank you in advance! Had a bit of smoke coming out of my ears trying to figure it out.