Results 1 to 5 of 5

Thread: EXCEL (XP)

  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Kentucky, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    EXCEL (XP)

    Post deleted by julieq79

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EXCEL (XP)

    What you're saying is not very specific. There are number of other Loungers who have explored this - including posting their samples. Have you tried searching on the Excel Board to see if they have tried to do something similar. Alternatively could you post a fuller example or a sample workbook? HTH
    Gre

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: EXCEL (XP)

    Will the attachment get you started?

    [i][Oops! Edited to remove password protection.][i]
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7DS

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Location
    Kentucky, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EXCEL (XP)

    Thanks, but I have my spreadsheet set up that way now. I was looking for a way to have my balance column know whether to add or subtract by it reading another column that I type in dep(for deposit) or chk(check). Does this make since? columns: date, dep/chk, amount, balance.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EXCEL (XP)

    On the basis of the "dep/chk" being in Column B, the amount in Column C and the balance in Column D, try something like this in D3:

    =IF(B3="dep", +C3+D2, -C3+D2)

    That would automatically deduct the amount, unless you put in "dep" (spelled correctly, of course <img src=/S/smile.gif border=0 alt=smile width=15 height=15>).
    If you wanted error-checking, you could try:

    =IF(B3="dep", +C3+D2, IF(B3="chk", -C3+D2, IF(B3="", +D2, "spelling??"))

    The third part of the formula ignores Column C (whether or not it is empty) until you put an entry in Column B. Anything that isn't "dep" or "chk" is marked as a spelling error. HTH
    Gre

Posting Permissions

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