IF(OR) Help needed

JDigrazia

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) 

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

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.

Jason Rowe

NVM. Looks like you figured it out.