Pls. suggest me any formula in excel that can auto calculate the average Rate as per FIFO method from Purchase Rate, as sale Qty mentioned for reference I attached a excel sheet
Pls reply as soon as possible
Thanking you.
Pls. suggest me any formula in excel that can auto calculate the average Rate as per FIFO method from Purchase Rate, as sale Qty mentioned for reference I attached a excel sheet
Pls reply as soon as possible
Thanking you.