Results 1 to 7 of 7

if function with error checking

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2009
    Location
    Japan
    MS-Off Ver
    Excel 2003
    Posts
    32

    Red face if function with error checking

    Hello

    My file looks like this:

    Column
    A - number of pieces (manual input)
    B - x dimension of area (manual input)
    C - y dimension of area (manual input)
    D - area based on B and C (formula = B*C)
    E - irregular area (manual input, if area is not rectangle)

    F- solve for density number (pcs/area)

    my first code, assuming ROW 1
    
    =IF(D1=0,A1/E1,A1/D1)
    
    this code is ok but it will give DIV/0 error if B or C is blank.
    I want Div/0 be blank/zero
    my 2nd code does not work
    
    =IF(D1=0,A1/E1,IF(ISERROR(A1/D1),"",(A1/D1)))
    TIA
    Last edited by smalltime; 02-28-2010 at 11:38 PM. Reason: correct code

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