+ Reply to Thread
Results 1 to 2 of 2

How do you make blanks in IF

  1. #1
    Registered User
    Join Date
    07-29-2008
    Location
    Canada
    Posts
    3

    How do you make blanks in IF

    hey i have to make a graph and the data for the graph is created using an if statement.

    ie:
    =if(A1>10,A1,0)

    if the value is false i dont want it in the graph but i cant make the if statement output a blank cell. If the if statement output a blank cell then those data points would not appear in my graph.

    Is this possible?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    For a blank, =if(A1>10, A1, "")


    For not plotting, =if(A1>10, A1, NA())

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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