Formula AND OR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
: Again thanks
 
=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?
 
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
 
If you have IF(B29="select","","")) then you're never going to get the "New
Schedule" that you asked for, but I'm glad that you're happy.
 
Back
Top