GREAT, thank you for problem solving
in formula mention "N" , what is definition ?
Thank you
Try,
1] In "Balance" G4, formula copied down:
=IF((DAY(B4)=1)+(A4-N(A3)=1)+(B4-N(B3)<0),E4-F4,G3+E4-F4)
2] In "Lead time" H4, formula copied down:
=IF((DAY(B4)=1)+(A4-N(A3)=1)+(B4-N(B3)<0),1,B4-B3)
View attachment 82480
Month | Date | Material | Material Description | GR | Allocation | Balance | Lead time |
9 | 02/09/2022 | 705-64-01 | GLOWREADY-4,3G-01 RED GO | 96 | #VALUE! | #VALUE! | |
9 | 08/09/2022 | 705-64-01 | GLOWREADY-4,3G-01 RED GO | 96 | #VALUE! | 6 | |
9 | 09/09/2022 | 705-64-01 | GLOWREADY-4,3G-01 RED GO | 48 | #VALUE! | 1 | |
10 | 17/10/2022 | 705-64-01 | GLOWREADY-4,3G-01 RED GO | 96 | 96 | 1 | |
10 | 25/10/2022 | 705-64-01 | GLOWREADY-4,3G-01 RED GO | 96 | - | 8 |
Please stick on your post#1 file.Dear Bosco
I am already copy formula, but still there #VALUE in A4,A5,A6 , and next line formula are ok. Could you help / suggest ?
Month Date Material Material Description GR Allocation Balance Lead time 9 02/09/2022705-64-01 GLOWREADY-4,3G-01 RED GO 96 #VALUE!#VALUE! 9 08/09/2022705-64-01 GLOWREADY-4,3G-01 RED GO 96 #VALUE!6 9 09/09/2022705-64-01 GLOWREADY-4,3G-01 RED GO 48 #VALUE!1 10 17/10/2022705-64-01 GLOWREADY-4,3G-01 RED GO 96 96 1 10 25/10/2022705-64-01 GLOWREADY-4,3G-01 RED GO 96 - 8