Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: "" to 0 within equation?

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question "" to 0 within equation?

    Hi you wonderful people!

    I'm using the current formula =IFERROR(IF($AR3<=(BU$1-5),SUM(V3:Y3),""),"")

    Filling in false values and errors with blanks so I can perform a countif >=0 in a later step.

    However, I am trying to subtract one of the blank cells from a number and am getting a #value ! error. Any way around this?

    Thank you in advance for your wonderful help.

  2. #2
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "" to 0 within equation?

    You'll have adjust the formula doing the subtraction to accomodate the "" result of that formula.
    Maybe just use IFERROR on that one as well.

    Or test if it's "" with an IF.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  3. #3
    Board Regular
    Join Date
    Mar 2014
    Posts
    2,032
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "" to 0 within equation?

    Quote Originally Posted by jencha View Post
    I am trying to subtract one of the blank cells from a number and am getting a #value ! error. Any way around this?
    No idea what your formula looks like. (Hint!) But perhaps something like this:

    1234 - N(X1)

    where X1 is the cell that might contain text (the null string, presumably).

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •