View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Function question

In B1, put formula =FACT(A1)

HTH,

--
AP

"Tim" a écrit dans le message de
...
I want to take a number and then do a sum similiar to a factorial.

Example:

In cell A1 I input 5

then in cell A2 the function adds 5+4+3+2+1

if I put in 3 it adds 3+2+1

is there a function that does this?