Raja Nazir
New Member
- Joined
- Apr 22, 2021
- Messages
- 1
- Office Version
- 2013
- 2010
- 2007
- Platform
- Windows
Hi,
I 'm a vaccinator , I have to maintain stock book of vaccine. vaccine vial comes in different doses. So until the dose is, we have to place the same previous value.
for example a vaccine vial of TT comes in 20 doses,
now, I have used 4, 6, 8, 4(=22) doses in four days, so On fourth day i will have to open a new vial, until then, I want the same quantity in total column that is 220, and on fourth day,the formula subtract only 20 doses .
is there any formula for that, it will save my time and will be thankful
I 'm a vaccinator , I have to maintain stock book of vaccine. vaccine vial comes in different doses. So until the dose is, we have to place the same previous value.
for example a vaccine vial of TT comes in 20 doses,
is there any formula for that, it will save my time and will be thankful