If condition

[nasya_azureen]

Hello! I have a simple problem yet I couldn't fine any if else formula that fits to solve the issue. I have two columns; [shipping_state] and [shipping_country]. I want to make it auto-fill if [shipping_state] is not blank, then [shipping_country] must automatically fill out "MYS". This is the only condition that I want to put into the formula. I tried to use IIF but I couldn't make the second column to fit into the formula.

[Qiu · Accepted solution]

@nasya_azureen 

We can do something as below, but I suspect your condition is " [shipping_state] is not blank"?

[nasya_azureen]

Yes, the condition for [shipping_state] is not blank and your solution worked out very well! Thank you!

[Qiu]

@nasya_azureen 
Glad it works. Thank you for the feedback!