Hello,
Which is the best formula to use when creating an if then formula with one criteria. In the example attached, I need the formula that if under column Type it equals to City to return the City Name. If Type is State to return the State.
Thanks,
Maylen
Solved! Go to Solution.
@verde0903 using IIF() statement
IIF([Type] = 'City',[City Name],IIF([Type]='State', [State], Null()))
Thank you. It worked.
Thank you. Both suggestions worked.