Results 1 to 6 of 6

Combing multiple IF Statements.

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    South Korea
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    68

    Combing multiple IF Statements.

    I am trying to join these to formulas together but keep getting a FALSE statement in the target cell

    What I want to accomplish is if the these 3 cells are blank it will say NO RECORD in the target cell

    =IF(OR(ISBLANK(F2),ISBLANK(G2),ISBLANK(H2)),"NO RECORD",

    &

    =IF(OR(F2="NA",G2="NA"),SUM(F2:H2)&" (PROFILE)",IF(OR(H2="Walk",H2="Swim",H2="Bike"),SUM(F2:H2)&" (ALT EVENT)",SUM(F2:H2)))
    Attached Files Attached Files
    Last edited by Bobby82; 11-21-2012 at 01:26 AM.

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