#1
|
|||
|
|||
Mail merge field help for percentage null values
Hi Guys
I need your help to generate as empty if cells empty in excel mail merge. I have used the below field but return as 0.00% instead of empty. { =0*100 \# "0.00%" } If cells have values then above field code working fine but if nothing in excel cell return as 0.00%. So please help out on this issue My field code name is "Prod Quality_". thanks Ganesan. G |
#2
|
||||
|
||||
Do you mean like
{ IF { MERGEFIELD Prod_Quality_ } <> "" "{ = { MERGEFIELD Prod_Quality_ }*100 \# "0.00%" }" }
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Hi
Yes it is!! But how to incorporate this filed code in to my document? Above field code returns "Mergefield" instead of null or cell value. thanks Ganesan.G |
#4
|
||||
|
||||
Each pair of brackets { } indicates a field. (CTRL+F9)
Either construct the elements manually or convert the text to fields using Import and export field constructions as text
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#5
|
|||
|
|||
Hi
I have tried as you said but returns only "MERGEFIELD" instead of empty or respective data value. I think something need to update in this field code as if condition is false return as "". Can u please advise on this? |
#6
|
||||
|
||||
If the field name is, as you suggested "Prod_Quality_" then the field construction will produce a blank in place of the empty field, or the calculation for a numeric value. The fact that you say it produces MERGEFIELD suggests that you have not entered it correctly. Copy it from my earlier reply and use the add-in to convert it to working fields.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#7
|
|||
|
|||
I tried it but got below format
IF 0.99629999999999996 <> "" "99.63%" or 0.00% |
#8
|
|||
|
|||
These documents i have used attached here.
Can you please investigate and advise? |
#9
|
||||
|
||||
See attached
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#10
|
|||
|
|||
Awesome!! finally got it
Thanks much gmayor!! |
#11
|
|||
|
|||
Hi gmayor
One quick question Can we link excel mail merge data from MS-Teams app. I have the data in excel and stored in MS-Teams. So please let me know if options there. |
#12
|
||||
|
||||
Sorry I don't know anything about MS-Teams
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#13
|
|||
|
|||
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 |
#14
|
||||
|
||||
The following will work (see attached)
{ IF { MERGEFIELD Prod_Quality_ } = "NA" "NA" "{ IF { MERGEFIELD Prod_Quality_ } = "" "" " { =({ MERGEFIELD Prod_Quality_ }* 100) \# "0.00%" } "} "}
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
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 |