catch the amount of negative numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphing Negative Time 1
random number generation help 3
IF Logic Function with negative time or early time 1
Fill color if amount is negative 1
Conditional Formatting / Positive vs. Negative 4
Variable not defined for "number of trials" ? 3
Type Mismatch error when number is negative 5
Excel - Match positive and negative numbers 9

Back
Top