Simple Excel Spreadsheet question
Favorites|Homepage
Subscriptions | sitemap
HOME > > Simple Excel Spreadsheet question

Simple Excel Spreadsheet question

[From: ] [author: ] [Date: 12-09-04] [Hit: ]
26-A probability is always between zero and 100 percent inclusive.You have 163% which is not a valid probability.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.B1x=B3,......
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

-
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.

-
Could you rephrase the notation
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).

-
Repost, telling me exactly what you want to see because i don't understand what you want
1
keywords: Simple,Excel,Spreadsheet,question,Simple Excel Spreadsheet question
New
Hot
© 2008-2010 http://www.science-mathematics.com . Program by zplan cms. Theme by wukong .