+ Reply to Thread
Results 1 to 3 of 3

Formula for range of cells

  1. #1
    Registered User
    Join Date
    03-15-2016
    Location
    Napier New Zealand
    MS-Off Ver
    2010
    Posts
    26

    Formula for range of cells

    I have a spreadsheet, that I want to have cell D;4 to equal 1 if cells D;1, or D;2, or D,3 have a value in
    Can someone please give me an idea of what formula to use, as I get a #VALUE! error
    I tried =IF(D1:D3<>"","1","")

    Thanks in advance

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,677

    Re: Formula for range of cells

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

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,678

    Re: Formula for range of cells

    What does your last post mean? Please be more explicit .
    "1" is a text string. 1 is a number

+ 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: 3
    Last Post: 09-09-2019, 03:59 PM
  2. Formula to look at a range of cells, match dates within the range and pull data.
    By mark.k.conroy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-04-2019, 10:20 AM
  3. [SOLVED] Add IF Statement formula to cells in varying range and paste to used range
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-26-2015, 01:28 PM
  4. Replies: 1
    Last Post: 09-04-2013, 07:23 AM
  5. Replies: 1
    Last Post: 01-23-2013, 03:00 PM
  6. [SOLVED] VBA Copy a range of cells values using the range of cells in a formula (which will change)
    By murtaep in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 06-05-2012, 07:59 AM
  7. Replies: 2
    Last Post: 05-31-2012, 05:37 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