If statement using And, Value, Left, Functions, Number Ranges

[hgufrin]

Hello -

I sure would appreciate if someone could help me combine the following two formulas into one nested formula. They work individually but I simply am not able to successfully combine them.

=IF(AND(VALUE(LEFT(A2,5))>=61761,VALUE(LEFT(A2,5))<=61769),"Yes","no")

=+IF((LEFT(A2,4)="6170"),"Yes","No")

If a cell begins with 6170, return "Yes"

Or

If the left 5 characters of a cell begin with 61761 but are less than or equal to 61769, return "Yes".

Please note - the cell may contain letters such as 61761F which is why I put the "Value" function in there.

Thanks so much for your help.

 

[Fluff]

How about

=IF(OR(LEFT(A2,4)="6170",AND(VALUE(LEFT(A2,5))>=61761,VALUE(LEFT(A2,5))<=61769)),"Yes","no")

 

[hgufrin]

How about

=IF(OR(LEFT(A2,4)="6170",AND(VALUE(LEFT(A2,5))>=61761,VALUE(LEFT(A2,5))<=61769)),"Yes","no")

Unbelievable!!! Thanks so much!!!

 

[Fluff]

You're welcome & thanks for the feedback.