+ Reply to Thread
Results 1 to 4 of 4

Add IF IS BLANK to formula so blank cells stay empty

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Add IF IS BLANK to formula so blank cells stay empty

    My thought is that this is a basic excel question, but can someone help me insert an IF IS BLANK statement into the formula below;

    =VALUE(TRIM(CLEAN(G2)))

    Thank you!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Add IF IS BLANK to formula so blank cells stay empty

    perhaps this... =IF(G2="","",VALUE(TRIM(CLEAN(G2))))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Add IF IS BLANK to formula so blank cells stay empty

    Perfect! Thank you!

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Add IF IS BLANK to formula so blank cells stay empty

    You're very welcome, AND thank you for the rep!

+ 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. Need XNPV formula to ignore blank/empty cells
    By DeceivedHydra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2018, 02:46 PM
  2. [SOLVED] How to handle formula with blank (not empty) cells in column
    By 63falcondude in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2018, 03:45 PM
  3. [SOLVED] Counting blank cells that are empty buy contain a formula...
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2014, 11:15 AM
  4. Pivot table in blank cells it says blank.... i want it empty
    By appell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2014, 09:43 AM
  5. Replies: 5
    Last Post: 01-12-2013, 12:16 AM
  6. time formated cells stay blank if zero
    By dazza67 in forum Excel General
    Replies: 6
    Last Post: 11-01-2011, 08:19 PM
  7. Making cells with a 0.00 just stay blank?
    By jonvanwyk in forum Excel General
    Replies: 1
    Last Post: 06-29-2010, 01:48 PM

Tags for this Thread

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