+ Reply to Thread
Results 1 to 3 of 3

How to recognize that AxB is the same as BxA?

  1. #1
    Registered User
    Join Date
    05-08-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    21

    How to recognize that AxB is the same as BxA?

    I'm trying to figure out how to get an excel document containing product dimensions (width x height) to recognize that, for example, 10x20 is the same as 20x10. Ideally I would just like to add another column to the sheet that puts all dimensions with the lowest value first, rather than the width first and then the height. This way I can sort by dimensions, or use a pivot table to count the exact number of products in each dimension.

    The columns I have right now are:
    A = width
    B = height
    C = w x h (using the formula A1&" x "&B1)

    How can I get column C to compare A&B and return the lower value x the higher value?

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: How to recognize that AxB is the same as BxA?

    =MIN(A1,B1)*MAX(A1,B1)
    Something like this?
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    05-08-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    21

    Re: How to recognize that AxB is the same as BxA?

    That worked perfectly, thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to recognize that a cell contains a #?
    By rsavarain in forum Excel General
    Replies: 1
    Last Post: 09-07-2012, 03:15 AM
  2. [SOLVED] How to recognize that a cell contains a #?
    By rsavarain in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2012, 07:31 PM
  3. recognize last row and add
    By nattyborneo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2011, 08:35 AM
  4. [SOLVED] Recognize ALT key Pressed
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2006, 05:55 PM
  5. Recognize #div/0!
    By JOn Kunces via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 07-14-2005, 12:05 PM

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