Status:
New
FIFO.COST(array_qt_products_in;array_price_of_products_in;array_qt_products_out)
I've created a formula to get the FIFO cost of the last product that is going out of the inventory. It needs 3 arrays. The first array is the array that gets the quantity of the products going in t...
This LAMBDA demonstrates that FIFO inventory costing can be implemented using native Excel functions, but the complexity and maintainability issues highlight the need for a built-in FIFO function.