+ Reply to Thread
Results 1 to 5 of 5

#value error IF formula

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    #value error IF formula

    Hi Experts,
    I'm using IF formula but the bottom row is showing the #value, I have tried If error formula but it is not working, any expert can help me.

    Thanks in Advance.

    Regards.
    Aaru
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,246

    Re: #value error IF formula

    Post a sample workbook. See the yellow banner at the top of the page.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: #value error IF formula

    we cant see whats in S3 or Z3 - better to use a sample spreadsheet - see yellow banner
    The formula looks OK - it will depend if there is an ERROR in Z3

    IFERROR should work

    =IFERROR ( IF(,,,,,)) , "" )
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: #value error IF formula

    Thanks, Etf, it is working now.

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: #value error IF formula

    you are welcome

+ 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] Error with formula - need help finding the error in my formula
    By cabinet12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2020, 02:53 PM
  2. Formula not returning correct result. Formatting error or formula error?
    By Yonex1975 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2019, 02:38 PM
  3. [SOLVED] Macro To IGNORE ERROR - Cell With Formula / Green Arrow Error
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2018, 09:16 PM
  4. [SOLVED] FORMULA Remove #NUM error not using IFERROR OR IS ERROR
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2017, 04:22 PM
  5. Formula error or data link error
    By sctr in forum Excel General
    Replies: 4
    Last Post: 09-19-2016, 09:15 AM
  6. [SOLVED] Inputbox error message. Formula you typed contains an error.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2013, 02:25 PM
  7. [SOLVED] Error values:DIV/0! error in SumProduct formula with no division
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM

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