Move the check for null values, isNull(), to the top or beginning of the formula.

For example:

isNULL({FIELD1.EN_US}) 
then "No Value"
else if {FIELD1.EN_US} = "abc" 
then "xzy"

etc...