+ Reply to Thread
Results 1 to 3 of 3

formula if cell is blank do not apply formula

Hybrid View

JEAN1972 formula if cell is blank do... 10-16-2016, 10:12 AM
BadlySpelledBuoy Re: formula if cell is blank... 10-16-2016, 10:15 AM
JEAN1972 Re: formula if cell is blank... 10-16-2016, 10:57 AM
  1. 10-16-2016, 10:12 AM #1
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,141

    formula if cell is blank do not apply formula

    Trying to concatenate formula but need assistance to show nothing when cell is blank otherwise apply concatenate formula if there is data

    See attached actually showing().
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-16-2016, 10:15 AM #2
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,913

    Re: formula if cell is blank do not apply formula

    In cell B2 and copied down:
    Formula: copy to clipboard 
    =IF(A2="","","("&A2&")")


    BSB
    Reply With QuoteRegister To Reply
  3. 10-16-2016, 10:57 AM #3
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,141

    Re: formula if cell is blank do not apply formula

    Thank you for assistance
    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. Showing a blank cell where the formula does not apply
    By webcommerce in forum Excel General
    Replies: 5
    Last Post: 09-21-2016, 12:03 AM
  2. [SOLVED] VBA Apply Formula to Non Blank Cells in Range
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2014, 11:58 AM
  3. vba help to apply formula down till end of row data and where ever is blank in range.
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2013, 09:39 AM
  4. Skipping Blank cells in formula(searched but cant figure how to apply)
    By scotinexcile in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-21-2012, 09:14 PM
  5. [SOLVED] If I apply formula to my column can the cell be blank until data is added?
    By KELLIS in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-01-2012, 03:39 PM
  6. apply formula when value in column A is not blank
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2009, 04:35 PM
  7. Count last non blank column and apply to formula
    By Dukesford in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2007, 03:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1