#value!
Results 1 to 5 of 5

Thread: #value!
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2017
    Posts
    455
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default #value!

    hi,



    I inserted =IF(B16>0,B16*O10), but if B16 is blank i get '#value!' error , how can I resolve?

    FYI - cell 010 formatting = Currency (2 decimal places)

    KR
    Trevor3007
    Last edited by Trevor3007; Feb 1st, 2019 at 11:06 AM.

  2. #2
    Board Regular
    Join Date
    Jan 2014
    Location
    Dublin, Ireland
    Posts
    1,421
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: #value!

    what result do you want if its blank?

    possible solution : =IFERROR(IF(B16>0,B16*O10),"")

    note this will return FALSE if B16 was negative
    Learn something new everyday.

    be sure to use code tags

    Code:
    [ code ]
    [ / code ]
    ' no spaces

  3. #3
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: #value!

    Hi,

    That "Blank" in B16 must be a Formula Blank ( "" ), not truly blank/empty, otherwise you'll get FALSE rather than #VALUE with your current formula, try this:

    =IF(AND(B16>0,B16<>""),B16*O10,"")

  4. #4
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,734
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    4 Thread(s)

    Default Re: #value!

    Also:

    =IF(N(B16)>0,B16*O10,"")
    Office 2010/365

  5. #5
    Board Regular
    Join Date
    Jan 2017
    Posts
    455
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: #value!

    Quote Originally Posted by Scott Huish View Post
    Also:

    =IF(N(B16)>0,B16*O10,"")

    heyho BarryL

    thanks...works a treat

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
  •