+ Reply to Thread
Results 1 to 3 of 3

Show result Cell as Empty If.....

  1. #1
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Show result Cell as Empty If.....

    Hi All,

    I have this simple formula:

    Please Login or Register  to view this content.
    What i would like to do is:

    If the 2 cells in question are empty (In this case C11 and E11) then the cell with the formula in is also empty (Not showing 0).
    The First Cell in the Formula (In this case F10) might or might not have a value in.

    Any help is appreciated.

    Regards

    JRidge

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: Show result Cell as Empty If.....

    Try

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

  3. #3
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: Show result Cell as Empty If.....

    Hi zbor,

    Thank You

    Regards

    JRidge

+ 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. [SOLVED] Can a formula result in an 'empty' cell?
    By Cloth Ears in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-01-2014, 11:17 PM
  2. show empty cell if result is more than 20
    By fargobride in forum Excel General
    Replies: 4
    Last Post: 10-24-2009, 09:14 PM
  3. Replies: 4
    Last Post: 11-17-2008, 12:15 PM
  4. Macro to Find any empty cell within a range and show result in another column
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2008, 11:32 AM
  5. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 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