=IF(F46>0,F46*D46,IF(-F46<C57,F46<C57,F46*D57,IF(F46<C58,F57+((F46+C57*D58),IF(-F46<C59,F58+((F46+C58)*D59, IF (F46<C60, F59+((F46+C59)*D60),IF(F46<C61,F60+((F46+C60)*D61),IF(-F46<C62,F61+((F46+C61)*D62),IF(-F46<C63,F62+((F46+C62)*(D63),IF(F46 <IF(F46<C64,F63+((F46+C63)*D64),IF(-F46<C65,F64+((F46+C64)*D65),IF(-F46<C66,F65+ ((F46+C65+ ((F46+C65)*D66),IF(F46<C67+ ((F46+C66)*D67),IF(F46<C68,F67+((F46+C67)*D68),IF(-F46<C69,F68+(( F46+C68)*D69),IF(-F46<C70,F69+((F46+C69)*D70),ERR)))))
This is an example spreadsheet formula that calculates LIFO inventory balances & all possible layer liquidation possibilities for a company with 15 LIFO layers. These types of formulas are convoluted & require updating when used in subsequent years/pools. The high probability for an error to occur causes manual spreadsheet LIFO calculations to be unreliable.
Visit LIFO-PRO’s Services page to learn more about outsourcing your LIFO calculations to LIFO-PRO: