IF(OR) Help needed

Hi All -

I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help. Here is what I have:

=IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1) (doesn't work)

=IF((Status7 = "Red"), 1 (this works for red and sets the flag on for reporting purposes)

Find more posts tagged with

Formulas

Project Management

Comments

Jason Rowe

JDigrazia,

Try adding ,0 right after 1. So it will look like this.

=IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1, 0)

Hope this does the trick.

JDigrazia

Didn't work. Doh! Basically if the status is a red or yellow harvey ball (which works with the red formula) then I wan the flag to turn on. To turn it on, I need the "1" to enable the flag. Not sure what the 0 does here but I think it's with the [ ] and [ ].

JDigrazia

Woohoo fixed it

=IF(OR(Status6 = "Red", Status6 = "Yellow"), 1)

JDigrazia

Boom fixed it myself.

=IF(OR(Status6 = "Red", Status6 = "Yellow"), 1)

Jason Rowe

Oh yeah that's my bad. Looks like it will work with or without the 0.

I think your are right with the []. In your example is the name of the column "Status" and the row you are referring to 6? Try putting the ] in front of the number.