Results 1 to 7 of 7

IF Formula

Threaded View

  1. #2
    Registered User
    Join Date
    02-09-2009
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: IF Formula

    You are looking for a nested IF statement I believe. I'm still pretty new at this myself but it basically lets you pile several if statements into one.

    The syntax for the nesting the IF function is:
    
    IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
    
    This would be equivalent to the following IF THEN ELSE statement:
    
    IF condition1 THEN
        value_if_true1
    ELSEIF condition2 THEN
        value_if_true2
    ELSE
        value_if_false2
    END IF
    
    This syntax example demonstrates how to nest two IF functions. You can nest up to 7 IF functions.
    
    condition is the value that you want to test.
    
    value_if_true is the value that is returned if condition evaluates to TRUE.
    
    value_if_false is the value that is return if condition evaluates to FALSE.
    Watch your ()'s they get me everytime.
    Last edited by jvegastn; 03-16-2009 at 03:52 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