How to add 3 conditions to a Formula field

Hi Everyone,

I have the formula field below which works great. Basically if Account_Number__c contains '-1' it will populate ShippingStreet, else, BillingStreet.

IF(  CONTAINS(Account_Number__c , "-1") , ShippingStreet , BillingStreet)

Now, I want to add default address field so a third condition. So what I'm looking for is if Account_Number__c contains '-1' populate ShippingStreet, else, BillingStreet, if Billing Street is blank populate ShippingStreet.

April 26, 2017
·
Answer
·
Like
0
·
Follow
3

Jake Backues
IF( CONTAINS(Account_Number__c , "-1") , ShippingStreet , IF( ISBLANK(BillingStreet), "new default value", BillingStreet ) )

April 26, 2017
·
Like
0
·
Dislike
0

Maharajan C
IF( CONTAINS(Account_Number__c , "-1") , ShippingStreet , IF( ISBLANK(BillingStreet), ShippingStreet, BillingStreet ) )

Choose the best answer which one helps to you!!!