Syntax Help Needed for Using AND Statement in NEXIF

macropod · #1 05-06-2011, 02:22 PM

Hi Rob,

Your field construction is just fine. Did you use Ctrl-F9 for all the field brace pairs (ie '{}')?

There's a macro I wrote for converting the textual field representation into true fields at: http://www.gmayor.com/export_field.htm#TextToField

surrendertoo · #2 08-10-2011, 04:24 PM

Quote:

Originally Posted by macropod

Hi Rob,

Your field construction is just fine. Did you use Ctrl-F9 for all the field brace pairs (ie '{}')?

There's a macro I wrote for converting the textual field representation into true fields at: http://www.gmayor.com/export_field.htm#TextToField

I've also had issues combining criteria in a SKIPIF statement. Here's my code:
{ SKIPIF { = {IF {mergefield} < 1000 "0" "1" } + { IF {mergefield} < 2 "0" "1" } = "0" }

Can you identify any issues with this? Many thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't seem to get the correct syntax for Wine list mailmerge	daym	Mail Merge	3	05-02-2011 03:26 AM
Help with IF Statement	limpbizkit	Excel	4	02-24-2011 09:16 PM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM
Help with IF statement!	CPelkey	Word	1	04-12-2010 09:06 AM
Syntax help needed	blazzercat	Excel	3	07-09-2009 02:15 PM