+ Reply to Thread
Results 1 to 3 of 3

IF ISBLANK Error in Formula

  1. #1
    Forum Contributor
    Join Date
    07-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    139

    IF ISBLANK Error in Formula

    I have a named table on a worksheet that I am trying to use to track weekly bank transactions, much like a checkbook register. I am using the following formula to determine if the row contains a deposit or withdrawl and then this SHOULD add or subtract for the value above based on the conditions. However, when I enter the formula I get an error stating that there is an error in your formula and nothing more helpful than that.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    My table is as follows:

    trans.PNG

    I have a similar formula on a working transaction log that looks exactly like this, with the exception of the named table, that formula is below.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    that table looks like this:

    bnk.PNG

    Can anyone see the error in the first formula, as this has me stumped??

    Thank you

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: IF ISBLANK Error in Formula

    The last Withdrawal is missing its '['.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Forum Contributor
    Join Date
    07-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: IF ISBLANK Error in Formula

    wow, don't know if I feel more like a dumbass or stevie wonder!! Thanks so much, sometimes another pair of eyes is needed to solve the simplest of things. works great now, thanks again for pointing that out to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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