Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default =SUMIF PROBLEM

I'm working on a Straight Line Depreciation Spreadsheet (this was a "Home
Grown" effort -- touched by many hands, and not derived from an Excel
Template/Example)

Basically, I have the following ...
Cost (CELL M2) -- Life, in months (CELL L2) -- In-Service Date (CELL J2) --
Depreciation per month (CELL N2) -- Life/Cost)

Beginning 01/01/2005, I have an "Accumulated Depreciation Total" (CELL O2)
and the logic I want to apply is this:

IF Value in Cell O2 < Cost (CELL M2) then I want to populate CELL P2 with
the value of CELL P2 + the Monthly Depreciation (CELL N2) and continue this
on out (giveing an Accumulated Depreciation Total 12/31/06 and each
end-of-year until the value in any subsequent cell is equal to the Cost
(CELL M2).

Is there some code that I could use to manage this? For example (based on
the Life -- 60 months, 120 months, ect. -- Auto Fill the appropriate number
of cells to the right to correspond with the number of months in the Life
Cycle.

Thanks in advance for any assistance in this troubling problem.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif problem Dena Excel Discussion (Misc queries) 5 September 12th 08 03:16 PM
sumif problem Rick Excel Discussion (Misc queries) 2 February 6th 08 06:56 AM
Sumif problem Gerry Cornell Excel Worksheet Functions 6 January 9th 07 03:04 PM
SUMIF problem wahur Excel Worksheet Functions 2 May 9th 06 02:06 PM
SUMIF problem Aussie CPA Excel Worksheet Functions 1 February 18th 05 12:37 AM


All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"