+ Reply to Thread
Results 1 to 3 of 3

compare totals and provide a result

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    compare totals and provide a result

    I have a simple query, which needs resolution.

    I want to compare totals in row 2, columns A, B and C and the result is to be the lowest amount, but can't be zero.
    Column A will always have a number value, columns B and C may be of lesser value or even zero - however only one of B or C will have an amout, they will never both contain an amount at the same time.

    So if both B and C are Zero, produce result of A, if B or C have an amount give the lowest amount.

    A - B - C - D
    45 - 10 - 0 result 10
    80 - 0 - 20 result 20
    45 - 0 - 0 result 45

    Any ideas?
    Last edited by Christopherdj; 03-01-2012 at 08:17 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: compare totals and provide a result

    Not sure if this will work, works on your test data you might want to test other values

    =MIN(IF(A1:C1>0,A1:C1))

    Note: array formula, use Ctrl-Shift-Enter
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: compare totals and provide a result

    Excellent stuff, thanks - worked fine when I remembered to Ctrl-Shift-Enter

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1