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

[Guest]

In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!

 

[Guest]

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.

 

[Harlan Grove]

Once 0! is defined as being equal to 1, then n! =n((n - 1)!) for n a
positive integer.

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, {{}}.

 

[Max]

(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]

Max,

Your date is so very wrong that I will ignore you until 02/01/2025
18:35:32.

*plonk*

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

 

[Max]

Max,
Your date is so very wrong that I will ignore you until 02/01/2025
18:35:32.

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

 

[Dave Peterson]

Which reminds me of a sign that was in one of my highschool class rooms:

Be Alert
(The world needs more lerts!)

 

[Max]

(The world needs more alerts!)

aha, gotcha ! <bg>

 

[Amedee Van Gasse]

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

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

 

[Guest]

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?

 

[Dave Peterson]

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