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
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??? |
#4
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??? |
#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 |