Need help with an "if function" to improve a Forex trading journal

Hello,
I need your help!

I have not been able to make this IF function work.

Basically on the far right you will see a table under Fixed money management.

I want the Lots traded column to be automatically assigned to the "Lots" of the main trading log.

After each trade is completed the function should automatically set the Lots from the Fixed money management table based on the previous row's account balance.

The criteria is for example that if my account balance is between $5000 and $6499 .30 lots will be traded, and when my balance reaches the next level/row of $6500 .60 lots will be traded.

All other rows besides from the immediate next trade should be blank, until they are the next available trade.


I uploaded a blank template with some example trades so it can be understood how it works.

My file is linked a trading platform,open it and close it till it asks for an update; just click on don't update the file and it will work just fine for editing.


The password to unprotect my file is "forex"


Thanks in advance to everyone that helps.