Results 1 to 9 of 9

If and statement should = 0 instead of "true"

Threaded View

  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    If and statement should = 0 instead of "true"

    =IF(AND(B5="FamSick",C5=1),B49+B89,0)

    In my spreadsheet right now, the value of B5 is 0:00 while the value of C5 is 3. With this being the case, B49 and B89 should not be added to create a result. (Even if they were added, both contain a value of 0 right now, so that value would still be 0.)

    Instead of the above forumla equalling 0, it is making it equal TRUE. Any ideas?

    P.S. The formula in this case is found in cell B155
    Attached Files Attached Files
    Last edited by jonvanwyk; 07-14-2010 at 04:24 PM.

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