+ Reply to Thread
Results 1 to 2 of 2

How do i get a value if any of a group of cells are equal to ..........?

  1. #1
    Registered User
    Join Date
    01-31-2019
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    10

    Cool How do i get a value if any of a group of cells are equal to ..........?

    Hi All,

    Example: If any one of these cells A20:A28 show the word "RALPH" then cell C16 to read "Y" otherwise leave cell C16 blank.

    So if any single one of the cells from A20:A28 contain the word "RALPH", cell C16 to read "Y" or leave blank.
    Seems a simple task but I am struggling.

    I have tried; =IF(A20:A28="RALPH","Y","") entering this formula in C16. Result shows #VALUE!
    That is after entering the name RALPH in one cell of the range A20 to A28.

    Any assistance would be very helpful.

    Thanks

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: How do i get a value if any of a group of cells are equal to ..........?

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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] Macro for if cells with drop down list equal this, then other cells equal this
    By trubio77 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2017, 07:39 PM
  2. How to divide a group of numbers in to 3 groups as equal as possible.
    By herbeey in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-27-2013, 08:10 PM
  3. How do I group many numbers into 100 equal groups?
    By drdirt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2013, 11:29 PM
  4. Replies: 0
    Last Post: 02-04-2013, 03:25 PM
  5. Replies: 1
    Last Post: 02-17-2011, 04:05 AM
  6. Pasting Image if formula in group of cells is equal to 0
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2011, 04:41 PM
  7. Replies: 3
    Last Post: 09-13-2005, 06: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