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".

Try:

=IF(LEN(A2)<13,"Grade-B","Grade-A")

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

=IF(OR(ISBLANK(A2),LEN(A2)<13),"Grade-B","Grade-A")

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.

Thanks for your kind support.

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