Announcement

Collapse
No announcement yet.

Multiple IF statement

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple IF statement

    ........Name.........Value............Display
    .........Joe.............0.........Bid In Estimating
    (dots just hold the positions of the titles and data)
    List of Names
    Fred
    Joe
    Jim

    I want to display stuff based on 4 variables.
    1. If Value = spaces then the Display = blank
    2. If Value = 0 then Display = "Bid In Estimating"
    3. If Value > 0 then Display = "Decision Pending"
    4 If the Name is in the List of Names then Display = "Rebid"
    Note: If there is a name match in the list of names, then this supercedes all other checks and Re-Bid should display. If there is no match in the name list then the Value field checks should be made.

    How would you code this?

    Thanks!

    Rob

  • #2
    Re: Multiple IF statement

    A couple of questions first.

    1. What happens if the name is in the list and the value >0, or =0?
    2. When you say spaces, is the cell blank or does it contain actual spaces and if so, how many?

    Let's ignore the name in list part for now and assume that spaces mean a blank cell and we are looking at cell B2.

    =IF(LEN(B2)=0,"",IF(B2=0,"Bid In Estimating",IF(B2>0,"Decision Pending","Unknown Condition)))

    Comment


    • #3
      Re: Multiple IF statement

      Originally posted by Seti
      A couple of questions first.

      =IF(LEN(B2)=0,"",IF(B2=0,"Bid In Estimating",IF(B2>0,"Decision Pending","Unknown Condition)))
      Just a minor point - missing the last double quote.

      =IF(LEN(B2)=0,"",IF(B2=0,"Bid In Estimating",IF(B2>0,"Decision Pending","Unknown Condition")))

      Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
      Humanware: Older than dirt

      Old, slow, and confused - but at least I'm inconsistent!

      Rich
      (retired Excel 2003 user, 3.28.2008)

      Comment


      • #4
        Re: Multiple IF statement

        Thanks for catching that, shades.

        Comment

        Working...
        X