Mail merge field help for percentage null values

ganesang · #13 08-27-2021, 12:47 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
text-to-Fields failing - how get null for missing values?	guthrie	Excel	8	06-09-2016 08:36 PM
Display Null Values in Pivot as 0	lornalou	Excel	2	06-02-2016 10:39 AM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM
formating a percentage in a Mail Merge	dkalsow	Mail Merge	3	04-03-2012 03:38 PM
Eliminating zeros, null values and negatives in a column	jannie	Excel	1	06-22-2011 07:03 PM