validating stock

[shreekumarnair77]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sr No[/TD]
[TD]Name[/TD]
[TD]Recept Date[/TD]
[TD]Stock[/TD]
[TD]Used[/TD]
[TD]sent[/TD]
[TD]End Stock[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]abc[/TD]
[TD]1/4/18[/TD]
[TD]120[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]xyz[/TD]
[TD]2/4/18[/TD]
[TD]100[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]abc[/TD]
[TD]5/4/18[/TD]
[TD]100(auto)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]xyz[/TD]
[TD]10/4/18[/TD]
[TD]90(auto)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.