+ Reply to Thread
Results 1 to 3 of 3

Formula for range of cells

  1. 01-16-2020, 07:04 PM #1
    Kiwi den
    Kiwi den is offline
    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
    Reply With QuoteRegister To Reply
  2. 01-16-2020, 07:19 PM #2
    TMS
    TMS is offline
    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
    44,336

    Re: Formula for range of cells

    Maybe
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-27-2020, 11:28 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,444

    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
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to identify and show address of range cells related to range of dates
    By Mr.Castle in forum Excel General
    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. formula to return blank value if cell va;ie not in range but vlookup if in range of cells
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-04-2013, 07:23 AM
  5. How to loop through cells in a range and then apply a formula to an offset to that range.
    By AndrewMac in forum Excel Programming / VBA / Macros
    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. 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: 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1