Hi
I'm trying to build a spreadsheet that will be able to calculate current stock levels by taking into account what the last action was (e.g. stocktake, purchase, order), etc but I don't know how to write formulas that will do what I need them to do.
Any data from before the stocktake doesn't need to be taken into account, but if we've done a stocktake and then there have been orders or sales since then, I need that to be picked up.
So, if the most recent action was a stocktake (and the date in E2 was the most recent date), then B4=E4 (data is listed below dates starting from cell 4).
But if we've done a stocktake and then an order in or sale out, it will need to be B4=E4+C4-D4
Is it possible to even do this??
I'm trying to build a spreadsheet that will be able to calculate current stock levels by taking into account what the last action was (e.g. stocktake, purchase, order), etc but I don't know how to write formulas that will do what I need them to do.
Any data from before the stocktake doesn't need to be taken into account, but if we've done a stocktake and then there have been orders or sales since then, I need that to be picked up.
So, if the most recent action was a stocktake (and the date in E2 was the most recent date), then B4=E4 (data is listed below dates starting from cell 4).
But if we've done a stocktake and then an order in or sale out, it will need to be B4=E4+C4-D4
Is it possible to even do this??