Results 1 to 2 of 2

Thread: Formula required

  1. #1

    Formula required



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

    I require a formula for cell C1 given the following example....
    In cell A1 is the number 10
    In cell A2 is the number 8
    In cell B1 is the letter N
    In cell B2 is the letter N
    So, here's what I would like cell C1 to return based on the following...
    If B1 and B2 = N, then the lowest number in either A1 or A2 must be subtracted from the highest number in either A1 or A2.
    If B1 and B2 = S, then the lowest number in either A1 or A2 must be subtracted from the highest number in either A1 or A2.
    If B1 and B2 have a different letter, that is, one has an N and the other an S, then A1 is to be added to A2.
    .Thanks.

  2. #2
    Formula found.
    No reply required.
    Thanks.

Posting Permissions

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