Thread: Help with IF statement in word 2010
View Single Post
 
Old 04-05-2013, 11:11 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
And what do you want to do if neither text1 nor text2 = A1? The following assume you want to deduct nothing in such cases:
{IF{REF Text1}= A1 {=B1-3000} {IF{REF Text2}= A1 {=B1-4000}} B1 \# ,0}
or:
{=B1-{IF{REF Text1}= A1 3000 {IF{REF Text2}= A1 4000 0}} \# ,0}
Results are expressed as whole numbers with thousands separators.

Note: The field brace pairs (ie '{ }') for the above examples are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote