Microsoft Office Forums SKIPIF with multiple conditions and 0 and 1?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2019, 12:24 PM
jasendill jasendill is offline SKIPIF with multiple conditions and 0 and 1? Windows 10 SKIPIF with multiple conditions and 0 and 1? Office 2010
Novice
SKIPIF with multiple conditions and 0 and 1?
 
Join Date: Oct 2019
Posts: 1
jasendill is on a distinguished road
Default SKIPIF with multiple conditions and 0 and 1?

I conjured up this code based off of a couple different posts I've read. I could not get anything to return and I noticed that another user suggested using 0 and 1 in coordination with * and +... but I don't understand what those mean or how to use them. BUT... IT WORKS! Awesome.




It works. That's all I know... what I don't know is WHY it works. Can anyone help explain how to use 0 and 1 along with * and +? Also, what if, in the future, I needed a third condition... would I have to use 0 1 2? and what's the equal sign for?
Attached Files
File Type: docx SKIPIF.docx (11.4 KB, 2 views)
Reply With Quote
  #2  
Old 11-01-2019, 11:36 PM
macropod's Avatar
macropod macropod is offline SKIPIF with multiple conditions and 0 and 1? Windows 7 64bit SKIPIF with multiple conditions and 0 and 1? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,612
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See the relevant discussions in the Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
mailmerge, skipif

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting per multiple row conditions JamesTheNoob Excel 1 04-05-2019 11:20 PM
IF formula - multiple conditions rameen Excel 1 02-11-2019 12:37 AM
Alternative for Multiple If Conditions? zguan1 Excel 2 05-25-2017 09:12 AM
SKIPIF with multiple conditions and 0 and 1? Multiple If Conditions z941714 Excel 8 08-09-2015 04:12 PM
SKIPIF with multiple conditions and 0 and 1? Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM


All times are GMT -7. The time now is 08:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft