+ Reply to Thread
Results 1 to 5 of 5

Help comparing cells and displaying value Yes or No from the result of comparison

  1. #1
    Registered User
    Join Date
    11-09-2017
    Location
    Steamboat Springs, Colorado
    MS-Off Ver
    office 2016
    Posts
    3

    Help comparing cells and displaying value Yes or No from the result of comparison

    Hello, I'm looking for help setting up my inventory spreadsheet.

    I would like to have a value in cell A (my item inventory total) compared to a value in cell B (my par level for ordering). I would like to have to show in cell C "YES" if the value in cell A is less than cell B and "NO" if this isn't the case. Any help is greatly appreciated!

    Toris

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Help comparing cells and displaying value Yes or No from the result of comparison

    welcome to the forum. does this help you?
    =IF(A1<B1,"YES","NO")

    otherwise, do upload an excel sample so that we do not have to manually key in your data to do a testing.

    input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

    the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

    if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

  3. #3
    Registered User
    Join Date
    11-09-2017
    Location
    Steamboat Springs, Colorado
    MS-Off Ver
    office 2016
    Posts
    3

    Re: Help comparing cells and displaying value Yes or No from the result of comparison

    I'll plug it in and see! Thanks for the quick response, i'll be sure to get back to this in a moment.

    ~Toris

  4. #4
    Registered User
    Join Date
    11-09-2017
    Location
    Steamboat Springs, Colorado
    MS-Off Ver
    office 2016
    Posts
    3

    Re: Help comparing cells and displaying value Yes or No from the result of comparison

    Yes that was perfect! Thanks so much! I have a feeling I'll be on here a few more times before I'm all set, so thanks for the warm welcome.

    A followup? Is there any way to change the format of the yes or no value? ie: green and red color fonts?

  5. #5
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Help comparing cells and displaying value Yes or No from the result of comparison

    you're very welcome. that should go to a new thread. but you can consider conditional formatting for that. select the range you want to apply to (say from A1:C10)
    go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
    =$C1="Yes"

    Format a fill color you desire.

    repeat the steps for "No". formula:
    =$C1="No"

    or if you wish to simply highlight column C, it's easier. select the range you want to apply to (say from C1:C10). Home Tab -> Highlight cell Rules -> Equal to -> Yes
    format a color fill desired.

+ 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. Replies: 6
    Last Post: 01-07-2016, 12:03 PM
  2. Comparing the text content of a cell to another and displaying a result
    By schallpattern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2013, 04:39 PM
  3. Comparing cells in a column and adding result of comparison in cells of adjacent column
    By Lionel welshboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 05:37 AM
  4. Comparing Cells + Only displaying unique values.
    By AKK9 in forum Excel General
    Replies: 4
    Last Post: 09-14-2010, 08:35 AM
  5. Comparing cells and result enters the lower value
    By kayone in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-31-2009, 07:02 PM
  6. comparing cells and displaying the desired value
    By phil@micro in forum Excel General
    Replies: 2
    Last Post: 01-23-2009, 05:32 AM
  7. [SOLVED] Comparing Cells and Displaying Data
    By Keith Brown in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2005, 02:06 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