+ Reply to Thread
Results 1 to 3 of 3

Why "" is considered as a number

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    ITaly
    MS-Off Ver
    Excel 2016
    Posts
    4

    Why "" is considered as a number

    Hi everyone,

    I have an array of x and y data but I want to plot only a few data selected by me.
    For this reason I have created something like this: (have a look at the attached .jpg)

    xdata ydata selection selected x data selected y data
    A B C D E
    1 1.204234 49.359627 x IF(C1="x";A1;"") IF(C1="x";B1;"")
    2 1.202642 49.299625 x IF(C2="x";A2;"") IF(C2="x";B2;"")
    3 1.201362 49.239628 IF(C3="x";A3;"") IF(C3="x";B3;"")
    4 1.199451 49.179626 x IF(C4="x";A4;"") IF(C4="x";B4;"")

    But this gave me problems since "" is recognized as a number (or something else) and when I plot D and E columns the plot is wrong.
    If I substitute the formulas with "0" instead of "" I get a right plot but since I have to interpolate the selected data with a linear trend on the plot, the unselected null data would cause me a wrong interpolation.
    Why excel considers "" as a number (or something else) and what I can use instead of it?

    Thank you very much for your help

    Federicohelp.jpg
    Last edited by fbassi; 12-15-2017 at 06:28 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Why "" is considered as a number

    perhaps substitute "" with #N/A

    what result does that give you?

  3. #3
    Registered User
    Join Date
    12-15-2017
    Location
    ITaly
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Why "" is considered as a number

    Thank you very much, that worked:

    +IF(C1="x";A1;NA())

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. "Date" is considered as "Month" while filtering data
    By Dwelsten in forum Excel General
    Replies: 2
    Last Post: 11-29-2017, 07:14 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. [SOLVED] inputting a number representing "Time" spent on a "Task" under drop menu's
    By cubbymonkey in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-09-2014, 04:03 PM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. [SOLVED] Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 07:14 AM
  7. [SOLVED] macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2006, 10:20 AM

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