Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Multiple IF statement

  1. #1
    Join Date
    26th August 2004
    Location
    Pensacola, FL
    Posts
    12

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    3rd June 2004
    Location
    CT
    Posts
    611

    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)))

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    11th February 2003
    Location
    Near the Land of OZ
    Posts
    1,591

    Re: Multiple IF statement

    Quote 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)

  4. #4
    Join Date
    3rd June 2004
    Location
    CT
    Posts
    611

    Re: Multiple IF statement

    Thanks for catching that, shades.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. multiple if then statement?
    By shiggles in forum EXCEL HELP
    Replies: 1
    Last Post: June 11th, 2006, 07:34
  2. IF Statement with multiple criteria
    By Webbers in forum EXCEL HELP
    Replies: 5
    Last Post: November 1st, 2005, 14:02
  3. Multiple If Statement??
    By ConcreteMonkey in forum EXCEL HELP
    Replies: 6
    Last Post: October 30th, 2004, 00:20
  4. Add ISBLANK to Multiple IF statement
    By Webbers in forum EXCEL HELP
    Replies: 4
    Last Post: October 19th, 2004, 01:21
  5. Multiple effects of an IF statement?
    By Russell1981 in forum EXCEL HELP
    Replies: 4
    Last Post: August 19th, 2004, 06:13

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
  •  
porno