What does the exclamation point (!) stand for in a math equation .

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

Guest

In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!
 
4!=4×3×2×1
7!=7×6×5×4×3×2×1
Not as obvious:
0!=1
To link your question to Excel, look up FACTORIAL in Help.
 
Alan Beban said:
Once 0! is defined as being equal to 1, then n! =n((n - 1)!) for n a
positive integer.
Click to expand...

It's not mere convention or just a definition. In Set Theory approach, n! is
the cardinality of the set of permutations of n items (similar to Excel's
PERMUT(n,n)). 1! = 1 because there's only permutation, {{a}}. 0! = 1 because
the the empty set counts as such a set, {{}}.
 
(Re-sent, apologies for the unintentioned advance dating)

Think it stands for factorial, e.g.:

4! = 4 x 3 x 2 x 1 =24
3! = 3 x 2 x 1 = 6

and in Excel, you can use FACT() to calculate factorials

If you enter in A1: 4, put in B1: =FACT(A1)
B1 returns 24
 
Amedee Van Gasse said:
Max,
Your date is so very wrong that I will ignore you until 02/01/2025
18:35:32.
Click to expand...

Hey <g>, I did a re-post immediately then upon alert from a very alert Dave
P.<bg>, with an apology for the unintentioned advance dating. The lame, but
true reason: just changed me ole' harddisk at that time, din't notice that
the sys date (year) was out by so much ..
 
Which reminds me of a sign that was in one of my highschool class rooms:

Be Alert
(The world needs more lerts!)
 
Max shared this with us in microsoft.public.excel.misc:
Hey <g>, I did a re-post immediately then upon alert from a very
alert Dave P.<bg>, with an apology for the unintentioned advance
dating. The lame, but true reason: just changed me ole' harddisk at
that time, din't notice that the sys date (year) was out by so much ..
Click to expand...

Ego te absolvo.



Grrrr... my Latin is soooo rusty...
Oh wait, I never had Latin in school!
Whatever, never mind my ramblings.
--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
jfarrug wrote:
Now can anyone tell me how to call the excel "Fact(x)" function from a macro
where x can assume any positive value and is varied while the macro is
running?
 
Any positive value can be pretty large...

But in general:

Option Explicit
Sub testme()

Dim myNum As Long
Dim myFact As Long 'Use Double for really big numbers

myNum = 7
myFact = Application.Fact(myNum)
MsgBox myFact

End Sub
 
Back
Top