| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ORDER SUPPLIES
COL 1 SUPPLY COL 2 #in stock
col1=<1 enter #2 so I can order supply or enter the word order I don't know if I should just do a query, or what if function or what, but I want it simple. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ORDER SUPPLIES
You are too vague in your request so this is jst a guess -
A B C Supply InStock Availability 1 2 1 2 0 Out of Stock formula for Column C =If(B2-A21,"Out of Stock",B2-A2) whereas ReOrder will be the qty of stock already supplied. "NannaLuvs" wrote: COL 1 SUPPLY COL 2 #in stock col1=<1 enter #2 so I can order supply or enter the word order I don't know if I should just do a query, or what if function or what, but I want it simple. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Need to insert a counter for supplies ordering. | Excel Worksheet Functions | |||
| Where do I find a template for a small office inventory/supplies | Excel Discussion (Misc queries) | |||
| I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Linear Mode
