Results 1 to 5 of 5

Formula Coding for Factorials

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    10

    Formula Coding for Factorials

    I need to write a formula or a function that divides all the numbers from the previous year without having to input it manually.
    For example,
    Year 1 1 20
    Year 2 2 30
    Year 3 3 40
    Year 4 4 50

    So I need 20/1 , 30/(1*2), 40/(1*2*3), 50/(1*2*3*4).

    I have about 400 cells that I need to do so I can't input it manually. Is there a function i can use to solve this problem.

    For those that know finance, I am try to discount cash flows where each year has a different interest.

    Thanks for any help.
    Last edited by alouie457; 11-12-2009 at 06:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1