+ Reply to Thread
Results 1 to 13 of 13

errors and zeros

Hybrid View

  1. 07-29-2015, 07:44 AM #1
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: errors and zeros

    Hi,

    In G12: =IFERROR(G5/G8,"")
    G13: =IFERROR(G4/G10,"")
    G14: =IFERROR(G5/G9,"")
    Reply With QuoteRegister To Reply
  2. 07-29-2015, 08:14 AM #2
    barneyrubble1965
    barneyrubble1965 is offline
    Registered User
    Join Date
    11-16-2011
    Location
    Reading, England
    MS-Off Ver
    Excel 365
    Posts
    69

    Re: errors and zeros

    Hi, I want cell to only return a value if result is NOT 0, or #div/0! or #value! or any other error code
    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)

Similar Threads

  1. Converting errors and zeros to blanks in nested INDEX,MATCH & COUNTIF formula
    By viper1953 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-31-2014, 11:48 AM
  2. [SOLVED] Find unique values from range ( populated cells only) & not count zeros or NA errors VBA
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2014, 06:50 AM
  3. Average Ignore Zeros, with a buttload of commas, errors
    By moosemoosemoose in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-02-2013, 04:06 PM
  4. Frequency function omitting zeros and errors
    By ArekRos in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-04-2012, 06:11 PM
  5. Missing zeros (including all trailing and inbetween zeros)
    By mecham in forum Excel General
    Replies: 5
    Last Post: 04-09-2012, 02:28 PM
  6. I told Excel NOT to display zeros in cells w/out value, but functions create zeros
    By maxedison in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2008, 11:18 AM
  7. save text field w/ leading zeros in .csv format & not lose zeros?
    By Ques in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 02:06 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