Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Second opinion; Can anyone poke holes in this formula?

    Hi, I've attempted to automate a manual process: Calculate the net balances for the month using an If Statement/Vlookup functions.

    Attached is my example. I'd really appreciate a second opinion about it's integrity..see any potential flaws/problems?
    -
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Can anyone poke holes in this formula?
    I poked a few....

    poked.JPG


    At a quick glance, it looks solid. If error is nice touch.
    Last edited by Maudibe; 2013-02-22 at 13:49.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 483 Times in 460 Posts
    Hi

    Your formula in column K essentially says
    'if the JAN fund value is same as DEC fund value, then put in a zero, otherwise subtract Dec value from the JAN value'
    You might as well say more simply:
    "subtract Dec value from the JAN value", since if they are the same, then you will get a zero anyway.
    (see attcahed file for same results using simpler formula)

    The IFERROR puts a zero in if the Fund number is missing from either the DEC or JAN tables.

    You formula does not properly take into account these situations:
    1. Fund number in JAN table is new in JAN, i.e. doesn't previously exist in DEC table (so probably should return JAN value)
    2. Fund number in DEC table no longer exists in JAN table (so probaly should return "CLOSED")
    In both these cases, currently a zero would be displayed.

    zeddy
    Attached Files Attached Files

Posting Permissions

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