Formula to check a done box with if and or

Christina Oliver

I am trying to create a formula to check a Done box if the Status = Done or if the Status = N/A. Here is what I have =IF(Status25 = "Done", 1, 0), OR(Status25 = "N/A) but I am getting the unparsable error. Does anyone know what I am doing wrong?

David Tutwiler

I think this is a duplicate topic, but here is my response from the other topic copied here:

=IF(OR(Status25 = "Done", Status25 = "N/A"),1, 0)

Christina Oliver

Update, here is the updated formula that I have that still is not working: =IF(Status25 = "Done", 1, 0), OR(Status25 = "N/A")

David Tutwiler

I think this is a duplicate topic, but here is my response from the other topic copied here:

=IF(OR(Status25 = "Done", Status25 = "N/A"),1, 0)