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
|