IF Formula Creation

Emily McNeeley

Having a hard time grouping the portions of the formula correctly. Here are the conditions:

1. If Phase@row = "Phase One" and Status@row <> "Approved by RSA/BU" or "Pre-Existing Solution", then "High"
2. If Phase@row = "Phase Two" and Status@row <> "Approved by RSA/BU" or "Pre-Existing Solution", then "Medium"
3. If none of the above, leave blank

Megan Ryzenga

Hi Emily!

Try this:

=IF(AND(Phase@row = "Phase One", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "High", IF(AND(Phase@row = "Phase Two", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "Medium", ""))

Megan Ryzenga

Hi Emily!

Try this:

=IF(AND(Phase@row = "Phase One", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "High", IF(AND(Phase@row = "Phase Two", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "Medium", ""))

Emily McNeeley

@Megan Ryzenga Thank you! This works great :-)