divide a value in four boxes with a maximum value

Hello,

I'm searching for a long time now but cant figure out my problem.
So i'm hoping someone here can help me.

The problem.

I'm creating a basic fuel planner for an aircraft for Flight sim use.

The total fuel needed must be added to the two main tanks.
So i know i can use the formula : =L21/2.

But the problem is the two main tanks must be filled first and they have a maximum capacity of 412KG per tank.
I need 1236KG in total.

So that is the two main tanks full with a total of 824KG together.
That leaves me with a rest of 412KG

My drop tanks has a capacity of 350KG per tank.
So i need to add the rest fuel of 412 over the two drop tanks.

But is has to be automated.
The main tanks must fill to the value of 412KG and add the rest to the droptanks.

Can anyone give me an explenation how this sort of formatting works?

Below an example.

example_excel.png

Kindly regards,

Rick Winkelman

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.