Thread: Mail merge with filter using data inputted by user
View Single Post
 
Old 04-08-2013, 08:54 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Tornado70,

Quote:
what do the '1 0' parts do?
In each IF test, the output is either 1 or 0. The 1 or 0 from both IF tests are then multiplied, so that you get what is effectively an AND test (0*0=0, 0*1=0, 1*0=0, 1*1=1).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote