I am trying to make a pretty simple spreadsheet, to calculate the duration required to achieve a quota of events.
B1: Probability of event, per check
B2: Time in between checks, in minutes
B3: Quota of events.
B5: Total duration in minutes to achieve quota of events.
Now how I would see B1x=B3, B2x=B5
But I am not sure how I would go about telling Excel that.
Example
B1: 163%
B2: 20
B3: 75
B5: 920.26
B1: Probability of event, per check
B2: Time in between checks, in minutes
B3: Quota of events.
B5: Total duration in minutes to achieve quota of events.
Now how I would see B1x=B3, B2x=B5
But I am not sure how I would go about telling Excel that.
Example
B1: 163%
B2: 20
B3: 75
B5: 920.26
-
A probability is always between zero and 100 percent inclusive. You have 163% which is not a valid probability.
The operations that you describe in 'additional details' would be:
=B1/B3*B2
This should be placed in cell B5.
If you are trying to figure out the average duration to reach the quota, then that formula is not right.
The operations that you describe in 'additional details' would be:
=B1/B3*B2
This should be placed in cell B5.
If you are trying to figure out the average duration to reach the quota, then that formula is not right.
-
Could you rephrase the notation
B1x=B3, B2x=B5
What are the expressions supposed to mean?
B1x=B3, B2x=B5
What are the expressions supposed to mean?
-
NO idea what you're talking about dude.
Obviously you are in sales, marketing, or HR.....clarify please, and will respond in kind with the necessary answer(s).
Obviously you are in sales, marketing, or HR.....clarify please, and will respond in kind with the necessary answer(s).
-
Repost, telling me exactly what you want to see because i don't understand what you want