Inventory Adjustment Formula

[francoiscj1]

I have an inventory spreadsheet formula with the following columns:

Column A: Beginning Balance
Column B: Quantity Received
Column C: Quantity Issued
Column D: Loss/Adjustment
Column E: Ending Balance

My formula in Column F would be: Beginning Balance + Quantity Received - Quantity Issued + or - Loss/Adjustment = Ending Balance

I’m having problems with how to calculate this formula. Thank you for the help.

 

[Fluff]

Maybe
=SUM(A1:B1,D1)-C1