Results 1 to 5 of 5

Write A+B=B+A with Excel Function

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2019
    Location
    NA
    MS-Off Ver
    365
    Posts
    4

    Write A+B=B+A with Excel Function

    Hi all,

    I'm trying to build this model A+B = B+A with Excel function (pls let me know if this can only be done with VBA, i'm not too sure)

    Criteria:
    * A+B = B+A at all times
    * Require to check if this A+B = B+A is true
    * If not true, show the difference
    * A+B = some value
    * B+A = some value
    * It's possible that the value of A+B does not equal to the value of B+A
    * Be prepared for the subset content of A and B to expand...I've thought of listing out all possibilities and checking with vlookup but it would be too much to maintain when this grows to millions of pairs.

    Thanks,
    Yami
    Last edited by Yami_Excel; 11-06-2019 at 06:44 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Write Sub procedure to format excel and write case/if statement to text file
    By vbronton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2018, 08:26 AM
  2. Excel hangs when trying to use addfromstring function to write a macro
    By gows1982 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 03:29 AM
  3. How to write Macros function to open other Excel files?
    By AP Accountan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 12:52 PM
  4. Replies: 10
    Last Post: 12-10-2012, 03:26 PM
  5. [SOLVED] RE-write if function with isna function for more values
    By funtastic in forum Excel General
    Replies: 6
    Last Post: 07-12-2012, 04:33 AM
  6. How do I write this Function using Excel's IF
    By Unsafe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2007, 05:42 PM
  7. [SOLVED] How to write IF function in Excel 2000 when there are two conditi.
    By Dajana in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2005, 11:06 AM

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