Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Compute variance in two columns

    I have tried to set up a formula to compute the variance in Col G showing the difference in the values between Col C & F based on the account numbers on Col A & D

    I have shown the correct variance which I computed manually in Col H

    It would be appreciated if someone could kindly amend my formula to give me the correct answer in Col G
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I have amended my formula from

    Code:
     =IF(C2=0,"",IFERROR(C2-INDEX(F:F,MATCH(A2&"",D:D,FALSE)),C2))
    To (removed &"")

    Code:
     =IF(C2=0,"",IFERROR(C2-INDEX(F:F,MATCH(A2,D:D,FALSE)),C2))
    And it works perfectly

Posting Permissions

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