Results 1 to 8 of 8

Return x only if value in cell

Threaded View

Jayzon Return x only if value in cell 03-19-2018, 05:24 AM
sktneer Re: Return x only if value in... 03-19-2018, 05:54 AM
Phuocam Re: Return x only if value in... 03-19-2018, 05:56 AM
Glenn Kennedy Re: Return x only if value in... 03-19-2018, 05:57 AM
Jayzon Re: Return x only if value in... 03-19-2018, 06:36 AM
Glenn Kennedy Re: Return x only if value in... 03-19-2018, 06:58 AM
Jayzon Re: Return x only if value in... 03-19-2018, 07:06 AM
Glenn Kennedy Re: Return x only if value in... 03-19-2018, 07:12 AM
  1. #1
    Registered User
    Join Date
    02-23-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    28

    Return x only if value in cell

    Hi

    I am running this formula, but it also returns x in the marked cell if the cells i24;i30 are blank.

    Any suggestions on how to leave the marked cell blank if i24;i30 are blank.

    Only if there is a number in one of cells i24;i30 should it return x in the marked cell, if all are blank the marked cell should also stay blank.

    =IF(max(i24:i30)>=0;"x";"")
    Last edited by Jayzon; 03-19-2018 at 05:36 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to return a sum only if a specific cell contains data, else return blank cell
    By Teeay5324 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-03-2017, 11:18 AM
  2. [SOLVED] How to return address of the column or cell I select, not just return the value?
    By qzqzjcjp in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-18-2014, 04:57 PM
  3. Replies: 12
    Last Post: 10-10-2013, 10:02 AM
  4. [SOLVED] Formula to always return cell below what a vlookup would return
    By KCHEXCEL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2013, 12:57 AM
  5. [SOLVED] IF statement to return 0 if 0 in cell if not return formula
    By CraigieL in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-15-2013, 09:46 AM
  6. Replies: 0
    Last Post: 02-20-2012, 09:43 AM
  7. Replies: 5
    Last Post: 03-12-2010, 07:33 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