Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2018, 10:22 AM
NBVC's Avatar
NBVC NBVC is offline Conditional query ... Windows 10 Conditional query ... Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

if A2 is blank the length of A2 will be 0, therefore it is less than 13 and so you don't need to check for blank.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM
Conditional query ... Conditional Formatting Query kjdickman2010 Excel 1 02-13-2015 10:11 AM
Calendar Query mwh1002 Outlook 0 07-30-2013 08:50 AM
Conditional query ... Baseline query joday48 Project 6 01-25-2013 09:50 AM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:35 AM.


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