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.
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)