+ Reply to Thread
Results 1 to 4 of 4

If statement with blanks

  1. #1
    Forum Contributor
    Join Date
    11-13-2013
    Location
    California
    MS-Off Ver
    Excel 365 Apps for enterprise
    Posts
    180

    If statement with blanks

    Hello,

    I have a sheet in which I have two columns that I want to supress zeros on. I know the if statement to use to do that, but my second if statement references the cell/column the first if statement is in, and is giving my a #VALUE! error. How can I suppress the zeros in both columns as applicable?

    I've attached what I'm referring to. Sample.xlsx

    - Column A is manual imput
    - Column B will only have a value if there is something entered in column A. The formula in Column B is =A2*75 which is then copied down through the sheet.
    - Column C is manual imput
    - Column D is = B2+C2 which is then copied down through the sheet.

    I want to suppress the zeros in B and D so the sheet looks cleaner and so that the user doesn't have to keep copying the formulas when they enter a new line of data.

    Please assist.
    Last edited by JennOlsen; 03-26-2014 at 06:56 PM.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: If statement with blanks

    Maybe these...

    =IF(COUNT(A2),A2*75,"")

    =IF(COUNT(B2),B2+C2,"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Contributor
    Join Date
    11-13-2013
    Location
    California
    MS-Off Ver
    Excel 365 Apps for enterprise
    Posts
    180

    Re: If statement with blanks

    Quote Originally Posted by Tony Valko View Post
    Maybe these...

    =IF(COUNT(A2),A2*75,"")

    =IF(COUNT(B2),B2+C2,"")
    Worked perfectly!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: If statement with blanks

    Good deal. Thanks for the feedback!

+ 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] Modifying =IF statement to ignore blanks
    By mrjinx007 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-31-2013, 10:05 AM
  2. Nested IF statement involving BLANKS
    By Lmsloman in forum Excel General
    Replies: 2
    Last Post: 07-02-2010, 03:29 PM
  3. if statement returning blanks
    By Mayrie in forum Excel General
    Replies: 3
    Last Post: 09-29-2009, 03:59 PM
  4. Replace 0s with blanks - IF statement
    By thomas.szwed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2007, 11:59 AM
  5. Charting cells with blanks from an if statement
    By mickeytrix in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-16-2007, 08:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1