+ Reply to Thread
Results 1 to 4 of 4

Compare 3 values and comment

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Compare 3 values and comment

    Hi All,

    I want to compare 3 values in rates colums (E,I,M) and make comment (Column O) based on output like Comment A, Comment B, Comment C..........Etc.
    Need comment to all possible scenarios.
    3 values can be equal or different to each other.
    For example
    A=B=C , Comment A
    A>B>C , Comment B
    A<B<C , Comment C
    A=B>C , Comment D
    A=B<C , Comment E
    A>=B>=C, Comment F
    .......
    .......
    .......

    Here with attached excel file.

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Compare 3 values and comment

    Hi,

    See if something like this formula will work for you..

    Please Login or Register  to view this content.
    Comment on 3 values.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Compare 3 values and comment

    Thank You Marvin.
    With your solution take me to think differently and solved the problem.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Compare 3 values and comment

    Hi thisara,

    Glad to help and thanks for the rep. So glad you could adapt to my answer. I had no idea if it would make sense for your problem.

+ 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. Paste Special BOTH values and comment
    By MAX258 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2017, 03:19 PM
  2. [SOLVED] Compare values from tables located in different sheet + adding comment
    By Rezo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2015, 03:13 PM
  3. [SOLVED] Returning cell values in a comment based on values in another workbook
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-10-2014, 04:13 AM
  4. [SOLVED] Need to compare multiple values including TIME between, and compare rate
    By fourmurphys in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2014, 04:37 PM
  5. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  6. Using values of cells in a comment
    By Bamaopoly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2006, 09:50 PM
  7. [SOLVED] RE: Using values of cells in a comment
    By Tom Ogilvy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2006, 04:50 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