Hello I got it the end of the formula should be IF(B29="select","",""))
then it works. thanks for your help could not have done it without you
guys

"David Biddulph" wrote:

=IF(B29=" $25,000 Annually ","Stipend",IF(B29="select","","New Schedule"))
but that's equivalent to the first answer Bernard gave you. Did you try
it?
--
David Biddulph

"Wanna Learn" wrote in message
...
THanks Bernard
Let me rephrase I will try to follow your pattern

if B29 = $25,000 answer should be "Stipend"
ifB29 = the word "select" then ""
if B29 equals anything else then "New Schedule"
hope this is better to undestand
"Bernard Liengme" wrote: Again thanks

Not sure I get question.
=IF(B29="select", "", IF(B29=" $25,000 Annually ", "Stipend", "New
Schedule") )
B29 result
select blank
25,000... stipend
anything else new sched.

Real AND/OR

IF(OR(B29=" 25,000 Annually", ISBLANK(B29)), "Stipend", "New schedule")
B29 result
blank or 25,000... Stipend
anything else New Schedule

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Wanna Learn" wrote in message
...
Hello
=IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to
do
is add to this formula if it says select then blank. or "" Not
sure
how to do this thanks