If begins

[Shrinivas]

I have 2 questions.
No 1-
Cell A1 contains numbers up to 10 digits. If number starts with 75 then B1 should return to YES.

No 2- in Cell value in A1 is greater than 750000 & less than 8000000 then B1 should return to YES

Thanks in advance,
Shrinivas

 

[FormR]

Hi, maybe..

1. =IF(AND(A1<10000000000,LEFT(A1,2)="75"),"Yes","No")
2. =IF(AND(A1>750000,A1<8000000),"Yes","No")

 

[gallen]

VBA solution:

Private Sub Worksheet_Change(ByVal Target As Range)
    
    Application.EnableEvents = False
    If Left(Range("A1"), 2) = "75" Then
        Range("B1") = "YES"
    ElseIf Val(Range("A1")) > 750000 And Val(Range("A1")) < 8000000 Then
        Range("B1") = "YES"
    Else
        Range("B1") = "NO"
    End If
    Application.EnableEvents = True


End Sub

 

[mrhstn]

Perhaps

=IF(OR((A2>750000)*(A2<8000000), LEFT(A2, 2)="75"), "YES", "")

 

[Shrinivas]

Thanks a million works perfectly,
Shrinivas.