| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I create a fifo formula in exel
-- Gary''s Student - gsnu200756 "heidic2" wrote: I have to create a formula that will calculate fifo and lifo in an inventory spreadsheet and I am completely lost |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I create a fifo formula in exel
For lifo, build a list in a column, inserting new entries at the top. When
pulling entries, pull from the top and delete that cell. For fifo, build a list in a column, insering new entries at the bottom. When pulling entries, pull from the top and delete that cell. -- Gary''s Student - gsnu200756 "heidic2" wrote: I have to create a formula that will calculate fifo and lifo in an inventory spreadsheet and I am completely lost |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I create a fifo formula in exel
This is a simple method for telling you the oldest and newest in inventory.
You can adapt it for your needs. I placed inventory in Col C. Column containing calculated days item in inventory must be in ascending order. Col A - Date item placed in inventory (hard date or formula such as "=IF(ISBLANK(B3),"",TODAY())" Col B - Item ID Col C (formula, assuming starting in row 3, format 'General') - "=TODAY()-A3", (Keep sorted in ascending order) Col D (formula for finding oldest) - "=VLOOKUP(MAX(C3:C10),C3:C10,1,TRUE)" Col E (formula for finding newest) - "=VLOOKUP(MIN(C3:C10),C3:C10,1,TRUE)" This should put on the right track for more sophisticated tracking. Ron "heidic2" wrote: I have to create a formula that will calculate fifo and lifo in an inventory spreadsheet and I am completely lost |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a fifo formula in exel | Excel Worksheet Functions | |||
| Can I use Exel to create Financial Statements? | Excel Worksheet Functions | |||
| How do I create shiftwork schedules in Exel? | Excel Worksheet Functions | |||
| How do I create a bar (1-100) in exel? | Charts and Charting in Excel | |||
| How to create a table to qualify a qty discount in exel | New Users to Excel | |||
Linear Mode
