One Condition If Then

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

One If Formula.xlsx

Workflow

Accepted answers

ShankerV

Hi @verde0903

One more way is to use the Formula tool also.

Many thanks

Shanker V

One Condition If Then.yxmd

binu_acs

@verde0903 using IIF() statement

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

verde0903

Thank you. It worked.

All comments

ShankerV

Hi @verde0903

One way of doing this with One IF formula is.

Many thanks

Shanker V

One Condition If Then.yxmd

ShankerV

Hi @verde0903

One more way is to use the Formula tool also.

Many thanks

Shanker V

One Condition If Then.yxmd

binu_acs

@verde0903 using IIF() statement

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

verde0903

Thank you. It worked.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335