Results 1 to 10 of 10

Need help with creating an if/then/or formula

Threaded View

danielneedssomehelp Need help with creating an... 04-21-2015, 11:35 AM
ConneXionLost Re: Need help with creating... 04-21-2015, 11:44 AM
AlKey Re: Need help with creating... 04-21-2015, 12:32 PM
Tony Valko Re: Need help with creating... 04-21-2015, 02:15 PM
danielneedssomehelp Re: Need help with creating... 04-21-2015, 03:09 PM
danielneedssomehelp Re: Need help with creating... 04-21-2015, 12:37 PM
ConneXionLost Re: Need help with creating... 04-21-2015, 12:42 PM
danielneedssomehelp Re: Need help with creating... 04-21-2015, 02:05 PM
AlKey Re: Need help with creating... 04-21-2015, 04:44 PM
danielneedssomehelp Re: Need help with creating... 04-21-2015, 05:27 PM
  1. #5
    Registered User
    Join Date
    08-06-2014
    Location
    Tucson, Arizona
    MS-Off Ver
    XP
    Posts
    43

    Re: Need help with creating an if/then/or formula

    So the array formula would only give a result of blank or "colors". How do I get it to return (1) blank if all cells are blank, (2) the word "color" if there is only text in one cell, and (3) "colors" if there is text in more than one cell?

    And I don't want to limit the kind of text that can be in cells A1:A50 to just different colors. In other words, if there is ANY text in cells A1:A50, that counts.
    Last edited by danielneedssomehelp; 04-21-2015 at 03:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Use an existing cell formula for creating a new more complex formula
    By dubcap01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2014, 07:41 AM
  2. Replies: 1
    Last Post: 11-21-2012, 02:03 AM
  3. Creating a formula
    By Californication in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2007, 07:16 PM
  4. Creating a formula via VBA
    By pik6235571 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-10-2007, 11:31 AM
  5. I need help creating a formula
    By Kim in forum Excel General
    Replies: 11
    Last Post: 11-19-2005, 04:10 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