![]() |
|
#1
|
|||
|
|||
![]()
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". |
#2
|
||||
|
||||
![]()
Try:
=IF(LEN(A2)<13,"Grade-B","Grade-A") |
#3
|
|||
|
|||
![]()
That does not take into account the "nothing" condition...
=IF(OR(ISBLANK(A2),LEN(A2)<13),"Grade-B","Grade-A") |
#4
|
||||
|
||||
![]()
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.
|
#5
|
|||
|
|||
![]()
Thanks for your kind support.
|
#6
|
||||
|
||||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
![]() |
kjdickman2010 | Excel | 1 | 02-13-2015 10:11 AM |
Calendar Query | mwh1002 | Outlook | 0 | 07-30-2013 08:50 AM |
![]() |
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 |