+ Reply to Thread
Results 1 to 4 of 4

Simpler way to do declining balance?

  1. 07-19-2007, 10:16 PM #1
    AlmostAGeek
    AlmostAGeek is offline
    Registered User
    Join Date
    07-18-2007
    Location
    Joliet, Illinois
    Posts
    30

    Simpler way to do declining balance?

    Since I have 45 lines to put this in (and 21 columns of budget #'s) is there a simpler formula for this?

    Budget 300

    Amt.... Balance
    10.... 290 <-formula in this cell=IF(E13<>"",$F$10-$E$13,"")
    10.... 280 <-formula in this cell=IF(E14<>"",$F$10-$E$13-$E$14,"")
    10.... 270 <-formula in this cell=IF(E15<>"",$F$10-$E$13-$E$14-$E$15,"")
    10.... 260 <-formula in this cell=IF(E16<>"",$F$10-$E$13-$E$14-$E$15-$E$16,"")
    10.... 270 <-formula in this cell=IF(E17<>"",$F$10-$E$13-$E$14-$E$15-$E$16-$E$17,"")
    10.... 260<-formula in this cell=IF(E18<>"",$F$10-$E$13-$E$14-$E$15-$E$16-$E$17-$E$18,"")
    10.... 250<-formula in this cell=IF(E19<>"",$F$10-$E$13-$E$14-$E$15-$E$16-$E$17-$E$18-$E$19,"")
    10.... 240<-formula in this cell=IF(E20<>"",$F$10-$E$13-$E$14-$E$15-$E$16-$E$17-$E$18-$E$19-$E$20,"")
    10.... 230<-formula in this cell=IF(E21<>"",$F$10-$E$13-$E$14-$E$15-$E$16-$E$17-$E$18-$E$19-$E$20-$E$21,"")

    etc, etc, etc

    Any help would be most appreciated.
    Thanks
    Reply With QuoteRegister To Reply
  2. 07-19-2007, 10:37 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524
    =f10-(sum(e13:e45)
    ect

    would be a good start
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 07-19-2007, 10:44 PM #3
    AlmostAGeek
    AlmostAGeek is offline
    Registered User
    Join Date
    07-18-2007
    Location
    Joliet, Illinois
    Posts
    30
    Thank you very much.

    I knew it had to do with SUM - I just didn't have my () in the right places.

    Thanks again!

    ON EDIT:

    =IF(E14<>"",$F$10-(SUM($E$13:E14,""))).....I need to incorporate into the formula so that it also blanks the cell if E14 doesn't have a number entered. It is possible that not all rows will have the $10 in it.

    When trying this I get the #VALUE error.

    Any further suggestions?
    Last edited by AlmostAGeek; 07-19-2007 at 10:55 PM. Reason: additional information
    Reply With QuoteRegister To Reply
  4. 07-20-2007, 02:29 PM #4
    Brigitte_P
    Brigitte_P is offline
    Registered User
    Join Date
    07-16-2007
    Posts
    43

    parenthesis in ifs and sums

    Your parenthesis (edited: I'm suddenly not sure parenthesis is a word in English. I mean brackets, like the things around this edit and in your formula) are not quite right.

    Try:

    Please Login or Register  to view this content.
    Brigitte
    Last edited by Brigitte_P; 07-20-2007 at 02:31 PM. Reason: english vocabulary
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1