validating stock

[shreekumarnair77]

Sr No	Name	Recept Date	Stock	Used	sent	End Stock
1	abc	1/4/18	120	10	10	100
2	xyz	2/4/18	100	10		90
3	abc	5/4/18	100(auto)
4	xyz	10/4/18	90(auto)

<tbody>
</tbody>

Hi
Need to set a formula which calculate the end stock(post consumption), however the present stock should automatically come once the product name is entered.

Pls help in setting the formula

 

[Marcílio_Lobão]

shreekumarnair77, Good morning.

This is not complicated to do.

But... where does the initial stock of your product come from?

From what line should there be formulas to automate the current stock?

Your example seems to be much simpler than actually being your reality.