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.

"scorpionest" wrote:

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

(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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"scorpionest" wrote in message
...
In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!

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?

"Max" wrote:

(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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"scorpionest" wrote in message
...
In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!

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


Jfarrug wrote:

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?

"Max" wrote:

(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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"scorpionest" wrote in message
...
In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!




--

Dave Peterson