Hi All

Can someone help me out on excel mail merge field function

I need to format percentage value based on the below conditions

If cell have empty return empty, if cell have NA return NA, if cell have values like 95.00% return that value.

I have used this code but not working properly

{ IF { MERGEFIELD Prod_Quality_ } = “NA” "NA" { IF { MERGEFIELD Prod_Quality_ } = “” “” { IF { MERGEFIELD Prod_Quality_ } <>"" }"{= MERGEFIELD Prod_Quality_ }*100 \# "0.00%" }" }}}

Please check and help me out