Nested If Formula
 

Based on actual file where g is a date L is a number and m,q,t are "yes" or
"no"

=IF(G24<1,"","Stage "&COUNT(G24,L24)+COUNTIF(M24:T24,"yes"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sharann via OfficeKB.com" <u23578@uwe wrote in message
news:a61793be1693f@uwe...
I have a spreadsheet of possible hiring canidates that may or may not go
through 5 stages of the hiring process which are listed below.

I need to know for instance if a candidate made it through some stages or
all
stages of the hiring process. Under the column headings (Attded Career
Session, Test Score, Chosen 4 1st interview, Chosen 4 2nd Interview,
Hired)
the data will be listed but Im not sure how to say Canidate 1 made it
through
all but the Chosen 2nd Intereview.

Canidate Attded Career Session, Test Score, Chosen1st interview,
Chosen2nd
Interview, Hired
1
2
3

Any help is greatly appreciated...thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201004/1