| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Please, I need help with a formula,
I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inventory and sales formula within a workbook. | Setting up and Configuration of Excel | |||
| Formula needed for too much inventory | Excel Worksheet Functions | |||
| inventory comparison formula?? | Excel Worksheet Functions | |||
| Need help with a formula in inventory | Excel Discussion (Misc queries) | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
Threaded Mode
