+ Reply to Thread
Results 1 to 2 of 2

formula to write-off the amount in cells evenly and sum them.

  1. #1
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    325

    formula to write-off the amount in cells evenly and sum them.

    Hello,

    I have amounts to be written off in Row No.2. I want to write off the values equally over a period of years depending on the periodicity entered in excel say for example ( 3 Years, 4 Years, 5 Years etc.,) I was able to do this manually. Can anyone help me with the logic to build a formula in single cell.

    I am herewith attaching the file wherein I have written off the values for 3 years.


    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,050

    Re: formula to write-off the amount in cells evenly and sum them.

    Please try

    =SUM(B3:B9)

    or

    =SUM(INDEX($B2:B2,MAX(1,COLUMNS($B2:B2)-$M$2+1)):B2)/$M$2
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-15-2020, 11:49 AM
  2. Distribute a total value evenly to an amount of cells considering certain conditions
    By jorgebeto16 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2017, 07:21 PM
  3. Split an amount evenly with condition
    By JustM3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-04-2014, 09:43 AM
  4. Replies: 4
    Last Post: 01-11-2013, 03:17 AM
  5. Replies: 7
    Last Post: 07-10-2012, 02:33 AM
  6. Replies: 1
    Last Post: 11-29-2010, 09:09 PM
  7. [SOLVED] how do write the amount of a number in text?
    By Alejandro-Venezuela in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-04-2006, 04:30 AM

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