+ Reply to Thread
Results 1 to 3 of 3

#value!

Hybrid View

Portuga #value! 04-05-2007, 05:05 AM
TomMoston =IF(ISERROR(A2-A1),"N/A",A2-A1... 04-05-2007, 05:39 AM
Portuga ThanksTom. Thats what I... 04-05-2007, 07:35 AM
  1. 04-05-2007, 05:05 AM #1
    Portuga is offline
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852

    #value!

    Hi,

    I have a simple formula in cell A3: =a2-a1 . My problem is that sometimes the values in a1 is "-". Whenever this happens I get the error #value! in column "C"

    Is there a way that I can have a formula in Column " C" that returns the message "N/A" instead of #value!
    ?

    Thanks
    Reply With QuoteRegister To Reply
  2. 04-05-2007, 05:39 AM #2
    TomMoston is offline
    Registered User
    Join Date
    11-28-2006
    Posts
    45
    =IF(ISERROR(A2-A1),"N/A",A2-A1)

    This should sort it for you.

    Cheers
    Tom
    Reply With QuoteRegister To Reply
  3. 04-05-2007, 07:35 AM #3
    Portuga is offline
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Quote Originally Posted by TomMoston
    =IF(ISERROR(A2-A1),"N/A",A2-A1)

    This should sort it for you.

    Cheers
    Tom

    ThanksTom. Thats what I needed!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1