Nested IF statements not working

ckerber · #1 08-21-2019, 09:56 AM

This worked in a previous document (from last year), but when I used the same doc with a new list (same fields), I got the "Error! Unknown op code for conditional" message. I've checked for missing & extra spaces, etc. but can't figure out what's going wrong.

I can't seem to paste here, so attaching a doc that shows the code.

macropod · #2 08-21-2019, 03:59 PM

Your field codes work fine for me. They are way over-engineered, though. See attached.

ckerber · #3 08-22-2019, 06:54 AM

Thanks--how so? Maybe if I can simplify, they'll work for me & be easier to re-use.

macropod · #4 08-22-2019, 03:18 PM

You might at least look in the attachment I supplied...

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
Help with nested If statements	Aliwoods	Excel	7	07-16-2018 06:18 AM
Conditional checkbox mailmerge: coding "or" statements within IF statements	mtracy16	Mail Merge	3	05-22-2018 02:03 PM
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date	mshu31	Word	1	02-09-2017 02:04 PM
Help with if then statements	brent chadwick	Word VBA	35	07-25-2015 02:41 PM
Using IF statements	stuwoolf	Excel	2	01-10-2015 01:58 PM