IF Statement formula

System

This discussion was created from comments split from: Multiple IF statements in a column formula.

Hawk23

Hi,

Can you advise how to write an IF statement for a column that is "Business Type" with one of two options - "De novo" or "Base Biz". I am trying to write a formula to look at the "location@row" and if it is one of four locations, in the Business Type column it should say De novo; otherwise, Base Biz (for all others).

Thank you!

Paul Newcome

@Hawk23 Try something along the lines of

=IF(OR(Location@row = "A", Location@row = "B", Location@row = "C", Location@row = "D"), "De novo", "Base Biz")