Results 1 to 2 of 2

Thread: Formula to compare pairs of cells in a row

  1. #1

    Formula to compare pairs of cells in a row

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have attached an example of a spreadsheet where I must compare stock share balances from two databases that should be equal but are sometimes different. I need a formula which will take two cells (in the first two rows) and return the mathematical difference. Then it must move to the next two lines and
    do the same calculation and continue on to the end. I cannot make anything work.

    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Wouldn't =B3-B4 do it?

Posting Permissions

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