midnightjynx
New Member
- Joined
- Jul 5, 2023
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I need to have this formula revamp where I add column A the first initial order Quantity be included. I want it included in the section when I used my First Initial Reorder point column C. All my reorder points are in Quarters and need to be displayed when I need to order and how much I need to order.
My first reorder point in column C and first Reorder quantity column A is different since I either need to deplete my stock or order immediately. Then after the first reorder point has come to pass then it needs to go into my 2nd Reorder point column D and use my second reorder quantity column B. This will then be used continuously for the remainder of the time frame.
Currently the formula I use is this.
=IF(OR(COLUMN(A:A)<$C2,MOD(COLUMN(A:A)-$C2,$D2)),0,$B2)
Put in screenshot with what the results should be
My first reorder point in column C and first Reorder quantity column A is different since I either need to deplete my stock or order immediately. Then after the first reorder point has come to pass then it needs to go into my 2nd Reorder point column D and use my second reorder quantity column B. This will then be used continuously for the remainder of the time frame.
Currently the formula I use is this.
=IF(OR(COLUMN(A:A)<$C2,MOD(COLUMN(A:A)-$C2,$D2)),0,$B2)
Put in screenshot with what the results should be