Formula to calculate required month
Hello Excel Guru,
I'm facing a problem to calculate and set the required month of my excipient list that I can take proper initiative to purchase.
Please help me if you have any solution.
See the "V" column that you can understand how i'm doing it right now.
Regards
Mustafizur Rahman
Change it
V2=T5-SUM(D5:R5)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Except for replacing =T5-(D5+E5+F5+G5+H5+I5+J5+K5+L5+M5+N5+O5+P5+Q5+R5) with =T5-sum(d5:r5) I have not clue about what you are trying to do.
Please give some explanation
Re: Formula to calculate required month
"T5" Is my stock, First (T5-D5) = If it turns in minus figure, I'm setting required month as Jan'16
Second (T5-(D5+E5)) = If it turns in minus figure, I'm setting required month as Feb'16
And I'm giving an input in "W" field that in which month the material is required first.
Regards
Mustafizur Rahman
W5Try this and copy towards down
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Edit: erased, nflsales seems to have understood the question way better then I
Thank you very much, you save the day.
Regards
Mustafizur Rahman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks