how do I create a fifo formula in exel
 

I have to create a formula that will calculate fifo and lifo in an inventory
spreadsheet and I am completely lost

how do I create a fifo formula in exel
 

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

how do I create a fifo formula in exel
 

You can download one example workbook "Fifo Inventory" (scroll to 3) from
below page

http://in.geocities.com/shahshaileshs/misc.htm


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins


"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