+ Reply to Thread
Results 1 to 4 of 4

Leave blank if error

  1. #1
    Forum Contributor
    Join Date
    11-03-2004
    Posts
    139

    Leave blank if error

    I would like to know how to make this formula not show #DIV/0! error if there is nothing to average.

    =AVERAGE(H86:K86)

    Thanks for you expert knowledge and help.
    Michelle
    Last edited by leem; 11-24-2010 at 09:18 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,011

    Re: Leave blank if error

    If you use XL 2007 (what would be nice to write in your profile) you can use IFERROR formula

    =IFERROR(AVERAGE(H86:K86), "")

    If you use previous version you can count values first:

    =IF(COUNT(H86:K86)>0, AVERAGE(H86:K86), "")
    Never use Merged Cells in Excel

  3. #3
    Forum Contributor
    Join Date
    11-03-2004
    Posts
    139

    Re: Leave blank if error

    Your right, sorry about that, Excel 2003. Thank you for your quick response and solving my problem. I really appreciate it.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,011

    Re: Leave blank if error

    Write in the profle please... Nobody will see this post next time you ask a question

+ 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