LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Help? Inverse factorial?

Not sure if I'm wording that right, or even if it's proper... or for that
matter, if what I'm talking about would be an inverse factorial(if there is
such a thing)... but... I asked this elsewhere but may have put a header
that caused people to not even read, so here goes again.

Basically what I'm trying to do is take a random number of places, and
divide 100% over those places, in a descending amount from first to last,
with first being the highest percentage.

IOW, let's say there were 4 places, the division would be something like
1st - 50%
2nd-25%
3rd-15%
4th-10%

I may have as few as say the 4 places above, or maybe as many as 100. I
don't know what that number will be.

I'm no mathematician(as you can see from my header*g*) but I'd think that
there has to be a mathematical formula to do this.

Thanks!
Shawn


--
It's not just based on number of championships won. Richard Petty won
200 races and 7 Daytona 500s in his 30+ year driving career. He also has
the most top-5s (555), top-10s (712), poles (126), laps completed
(307,836), laps led (52,194), races led (599) and consecutive races won
(10 in 1967) of any driver in NASCAR history.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
is it posible to have a formula for factorial via vba code? thread Excel Worksheet Functions 4 August 29th 14 11:02 AM
Factorial question M.M Excel Worksheet Functions 6 June 8th 09 04:33 PM
Factorial Listing Branson Excel Discussion (Misc queries) 3 June 6th 08 04:18 PM
Factorial (like =FACT) function? mr tom Excel Worksheet Functions 8 June 13th 06 01:45 AM
Range of Factorial Function Rushi Excel Discussion (Misc queries) 7 September 17th 05 12:28 AM


All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"