Avoiding Nested If statements

I'm working on a stock sales/ordering sheet. It's a much bigger version of the attached.

Each item has an average sales figure, Minimum Stock figure and then orders in the system coming over over the next 4 months. I have set up a sheet that forecasts each weeks stock sales and inwards with remaining stock on hand.

In Cell O6 you'll see a nested if statement that is calculating at which point the item will fall below Minimum Stock Requirements. I am hoping that someone can come up with a more elegant solution.

Thanks,
Tim

Hi All,

Thanks to anyone who has already had a look at this. I'm still bashing away here. Does anyone have any ideas?


Thanks,
Tim

Hi Benishiryo,

Thanks for that. Most helpful.

Regards,
Tim