One Condition If Then

[verde0903]

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

[ShankerV]

Hi @verde0903 

One way of doing this with One IF formula is.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @verde0903 

One more way is to use the Formula tool also.

Many thanks

Shanker V

[binuacs · Accepted solution]

@verde0903 using IIF() statement

IIF([Type] = 'City',[City Name],IIF([Type]='State', [State], Null()))

[verde0903 · Accepted solution]

Thank you.  It worked.

[verde0903]

Thank you.  Both suggestions worked.