Thread: Formula AND OR
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Formula AND OR

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