CODEWITHSUNDEEP
excelexcel-formulaformula
John Beasley
John Beasley

Reputation: 3075

Excel formula to check for text

I have this formula:

=IF(AD491="In progress" OR AD491="Reopened"(ROUND($BW$1-AI491,0),($BW$1-BB491+1))

It's checking if cell AD491 contains the words "In Progress" or "Reopened".

Excel is not allowing this formula.

I tried to do the following:

=IF(AD491="In progress") OR (AD491="Reopened")(ROUND($BW$1-AI491,0),($BW$1-BB491+1))

=IF(AD491={"In progress","Reopened"},(ROUND($BW$1-AI491,0),($BW$1-BB491+1))

But I'm still getting the Excel error.

How can I fix this?

Upvotes: 1

Views: 34

Answers (1)

norie
norie

Reputation: 9857

John

You have the syntax for OR wrong and you are missing commas.

=IF(OR(AD491="In progress",AD491="Reopened") , ROUND($BW$1-AI491,0), $BW$1-BB491+1)

Upvotes: 2

Related Questions