| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is it posible to have a formula for factorial via vba code?
In case you are not into Big numbers (numbers that excel does not normally handle)
Use worksheet.function in VBA. Uses fact() in excel in vba. On Monday, April 7, 2008 1:38:58 PM UTC+5:30, thread wrote: thanks it was very helpfull On 6 אפריל, 19:11, joeu2004 wrote: On Apr 6, 8:44*am, thread wrote: i'm trying to build a complex formula using factorial but i havent foud an operator that calculate a simple factorial,any idea? Perhaps the easy way is: WorksheetFunction.Fact(n) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Maximize posible? | Excel Discussion (Misc queries) | |||
| is it posible to do payslips for a small business in excel | Excel Worksheet Functions | |||
| Factorial (like =FACT) function? | Excel Worksheet Functions | |||
| Range of Factorial Function | Excel Discussion (Misc queries) | |||
| Creating "factorial" result from three lists... | Excel Discussion (Misc queries) | |||
Threaded Mode
