Results 1 to 4 of 4

Help With Error Values

Threaded View

  1. 03-08-2014, 03:51 PM #1
    annabean99
    annabean99 is offline
    Registered User
    Join Date
    03-06-2014
    Location
    Glasgow
    MS-Off Ver
    Excel 2013
    Posts
    6

    Help With Error Values

    Hi All
    I'm testing a spreadsheet I've been working on (with some much appreciated forum help). Where the data in a cell should be in the format BD1, BD2 etc up to BD10 - when error values are entered, the formula is reading the number value ** any 'letter number' combination whereas if two letters or two numbers are entered it throws up a #VALUE!.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ignoring error values
    By cheddarthief in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2010, 02:54 PM
  2. Code error due to less values
    By roberto1111 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2009, 05:26 PM
  3. How to average a set of values but ignore zero and error values (#N/A)?
    By klchoy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-17-2006, 08:02 AM
  4. Error loop through #N/A values
    By gti_jobert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2006, 04:40 AM
  5. 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

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