Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

1. I agreed to these rules
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. Established Member
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. Resident Old Codger
Join Date
11th February 2003
Location
Near the Land of OZ
Posts
1,563

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

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

## Re: Multiple IF statement

Excel Video Tutorials / Excel Dashboards Reports

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

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