Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2018, 11:48 AM
LearnerExcel LearnerExcel is offline Conditional query ... Windows 7 32bit Conditional query ... Office 2003
Advanced Beginner
Conditional query ...
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Conditional query ...

I want to get the result in Cell "B" as the following.

Cell "A" : 123456789123
Cell "A" :


Cell "A" : GDS123456789123R

Cell "A" Contains Nothing OR Less than 13 Characters THEN Cell "B" should be "Grade-B" Else Cell "B" should be "Grade-A".
Reply With Quote
  #2  
Old 02-01-2018, 12:40 PM
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

Try:

=IF(LEN(A2)<13,"Grade-B","Grade-A")
Reply With Quote
  #3  
Old 02-05-2018, 06:11 AM
gebobs gebobs is offline Conditional query ... Windows 7 64bit Conditional query ... Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

That does not take into account the "nothing" condition...

=IF(OR(ISBLANK(A2),LEN(A2)<13),"Grade-B","Grade-A")
Reply With Quote
  #4  
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
  #5  
Old 02-06-2018, 12:41 AM
LearnerExcel LearnerExcel is offline Conditional query ... Windows 7 32bit Conditional query ... Office 2003
Advanced Beginner
Conditional query ...
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

Thanks for your kind support.
Reply With Quote
  #6  
Old 02-06-2018, 01:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional query ... Windows 7 64bit Conditional query ... Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,915
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

In the future ,please post new questions ( even if you solve it yourself) in a new thread so that all members can profit from your solution
I did it for you this time
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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 11:09 PM.


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