Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum limit and marking
Hello,
My question is regards to marking where my data is at its limit. For example, if I have data for usage, but I want my limit to be at 100 items and have it mark where the limit is so I know when and where I had to put in an order. For example: Usage Limit 50 50 10 30 25 X 50 25 25 X So at A6 and A9 I had put in a new order. Is there a formula to mark when and where this limit occurs? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum limit and marking
I am having trouble visualizing the context in which you are working. I
think you are talking about something equivalent to a simple stock reorder system, so I will use that terminology. If "Usage" and "Limit" are in A1:B1, with the posted data in A2:B9, then =IF(init+COUNTIF(B$2:B8,"X")-SUM(A$2:A9)<reorder,"X","") in B9 may be what you are looking for, where init is the initial stock that you are using, and reorder is the stock level below which you want to reorder. Jerry Sum Limit and marking wrote: Hello, My question is regards to marking where my data is at its limit. For example, if I have data for usage, but I want my limit to be at 100 items and have it mark where the limit is so I know when and where I had to put in an order. For example: Usage Limit 50 50 10 30 25 X 50 25 25 X So at A6 and A9 I had put in a new order. Is there a formula to mark when and where this limit occurs? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|