+ Reply to Thread
Results 1 to 3 of 3

IFERROR / ISBLANK formula query

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    England
    MS-Off Ver
    Excel 2007 & Excel 2011 for Mac
    Posts
    79

    IFERROR / ISBLANK formula query

    Hi,

    I am running the following code that checks for text in column "A" and inserts several formulas into different cells if "A" contains some text.

    This all works fine and I don't wish to change anything except i cannot work out how to incorporate the IFERROR formula in so that the DIV/o error doesn't show. Any ideas????

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: IFERROR / ISBLANK formula query

    just test for 0
    Please Login or Register  to view this content.
    btw there is no Excel 2010 for Mac. there's 2010 for PC or 2011 for Mac :-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    03-25-2012
    Location
    England
    MS-Off Ver
    Excel 2007 & Excel 2011 for Mac
    Posts
    79

    Re: IFERROR / ISBLANK formula query

    Thanks Mate, works a treat.

    Well done for spotting the deliberate mistake!!

+ 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