+ Reply to Thread
Results 1 to 4 of 4

Conditional Expression in cell

  1. #1
    Registered User
    Join Date
    04-04-2006
    Posts
    2

    Conditional Expression in cell

    How would I put this into a cell as a formula? Other than some graphs, I'm new to excel. Be gentle with me.
    ***************

    IF B33 ISBLANK

    AND B34 ISBLANK

    THEN B28 EQUALS ZERO

    OTHERWISE B28 will show the formula =+b35/728

    ***************

  2. #2
    Registered User
    Join Date
    04-03-2006
    Posts
    14

    Combina IF & AND

    Hi
    try: =IF(AND(ISBLANK(B33),ISBLANK(B34)),B28=0,B35/728)

    here you're nesting IF with AND function and ISBLANK function.

  3. #3
    Registered User
    Join Date
    04-03-2006
    Posts
    14

    Combina IF & AND

    Hi
    try: =IF(AND(ISBLANK(B33),ISBLANK(B34)),B28=0,B35/728)

    here you're nesting IF with AND function and ISBLANK function.

  4. #4
    Registered User
    Join Date
    04-04-2006
    Posts
    2
    Quote Originally Posted by jordun
    Hi
    try: =IF(AND(ISBLANK(B33),ISBLANK(B34)),B28=0,B35/728)

    here you're nesting IF with AND function and ISBLANK function.
    jordun, thank you so much for answering me, and so quickly!

    I'm now tasked with doing the quarterly reports and I've inherited a spreadsheet that has quite a few problems. This resolves one of the major ones that I didn't know the syntax to. I use MS Access, and Excel has a lot of differences in syntax.

    Thanks again,

    TPB

+ 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