+ Reply to Thread
Results 1 to 4 of 4

How can I remove the #NUM from a cell and leave it blank?

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    Rhode Island
    MS-Off Ver
    Excel 2007
    Posts
    27

    How can I remove the #NUM from a cell and leave it blank?

    I have 6 columns of numbers and in the 7th column I want the lowest number from the six and in the eight column I want the second lowest and in the 9th I want the sum of the 7th and 8th columns. I am using this formula for the second lowest number: =SMALL(IF(F3:K3<>0,F3:K3),$A$4)

    The six columns do not all contain data yet. I only have data for the first two data entries right now. If there are 2 numbers it works fine. If there is text in the column it returns #NUM. I need this field to be left blank.

    How can I fix this?

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How can I remove the #NUM from a cell and leave it blank?

    Try

    Please Login or Register  to view this content.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: How can I remove the #NUM from a cell and leave it blank?

    Wrap your current formula in =IFERROR()


    EDIT: Ace_XL beat me to it
    Last edited by Spencer101; 02-09-2013 at 04:06 PM.
    If I've been of help, please hit the star

  4. #4
    Registered User
    Join Date
    01-31-2013
    Location
    Rhode Island
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: How can I remove the #NUM from a cell and leave it blank?

    I cut and pasted the formula and it left the cell blank but when I carried the formula down for the rest of the column it blanks out my data

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1