View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Boots
 
Posts: n/a
Default using iif statement

Sorry it does work. I'd spelt control wrong. thanks

"Peter Jamieson" wrote:

You could try a nested field

{ IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD
myfield }+1000000 }" }

(all the {} need to be the special field braces you can insert using
ctrl-F9.

That won't work if your field can contain non-numeric text, e.g. " " or
"abc" :-)

Peter Jamieson
"Boots" wrote in message
...
Hi.
Can I tweak a mergefield contents so that if the field is blank it stays
blank and if it contains a number it adds 1000000 to it?
thanks