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.
MD GULFAM (SR. ACCOUNTANT) (34 Points)
14 August 2019Pls. 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.
Kaushik
(Professional)
(549 Points)
Replied 14 August 2019
Hi MD,
See attached file.
MD GULFAM
(SR. ACCOUNTANT)
(34 Points)
Replied 19 August 2019
Thanks kaushik for your valuable reply, lets see how this file helpful for me, thanks once again.