A single formula?
I have an exercise that shows how to set up both types of inventory in my
Business & Management book (sorry for the plug!).
Copies available in libraries
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"heidic2" wrote in message
...
I have to create a formula that will calculate fifo and lifo in an
inventory
spreadsheet and I am completely lost