| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
catch the amount of negative numbers
Hello,
I am simulating a number of production runs and would like to catch the number of times we are running out of material = having the inventory level negative. I am simulating with a recorded macro doing calculate 50 times, and then i have a conditional formatting making the colours red every time we are running out of material, so it is possible to see it. What i would like to do is to catch the number of times. eg. a ticker that adds 1 to a variable, every time we have a negative number and then print the variable. Is this possible? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
catch the amount of negative numbers
Ok, I solved it myself...
"Tobias" skrev: Hello, I am simulating a number of production runs and would like to catch the number of times we are running out of material = having the inventory level negative. I am simulating with a recorded macro doing calculate 50 times, and then i have a conditional formatting making the colours red every time we are running out of material, so it is possible to see it. What i would like to do is to catch the number of times. eg. a ticker that adds 1 to a variable, every time we have a negative number and then print the variable. Is this possible? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change of negative amount | Excel Discussion (Misc queries) | |||
| Formula with negative amount | Excel Discussion (Misc queries) | |||
| How to display negative $ amount?? | Excel Discussion (Misc queries) | |||
| ENTER NEGATIVE AMOUNT | Excel Discussion (Misc queries) | |||
| Deleting a negative sign from an amount in a list (not trailing negative) | Excel Programming | |||
Linear Mode
