| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
an exact number if a number is less than
e.g., my inventory qty should always be 7. if inventory is at 3, i want a
formula to put a 4 in the order column. how do i do that??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an exact number if a number is less than
If the current inventory amount is in A1 try this formula
=MAX(0,7-A1) "Belinda" wrote: e.g., my inventory qty should always be 7. if inventory is at 3, i want a formula to put a 4 in the order column. how do i do that??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an exact number if a number is less than
Inventory quantity is in A1. Order cell is in B1. In B1 put
=IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order anything. If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"") "Belinda" wrote in message ... e.g., my inventory qty should always be 7. if inventory is at 3, i want a formula to put a 4 in the order column. how do i do that??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an exact number if a number is less than
i'll be doggone if that didn't work! THANKS a bunch.
"daddylonglegs" wrote: If the current inventory amount is in A1 try this formula =MAX(0,7-A1) "Belinda" wrote: e.g., my inventory qty should always be 7. if inventory is at 3, i want a formula to put a 4 in the order column. how do i do that??? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an exact number if a number is less than
that worked too!! THANKS Dave.
"Dave Thomas" wrote: Inventory quantity is in A1. Order cell is in B1. In B1 put =IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order anything. If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"") "Belinda" wrote in message ... e.g., my inventory qty should always be 7. if inventory is at 3, i want a formula to put a 4 in the order column. how do i do that??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| look for the exact number | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
