wild cards in formulas (numerical values)

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

=IF(C734=7905,D734*0.5,IF(C734=7925,D734*0.52,IF
(C734=7935,D734*0.8,IF(C734=7941,D734*0.6,IF
(C734=1170,D734*0.8,IF(C734=7956+AND
(a1=139068079),D734*0.8,d734*.7))))))

In the "and" statement, what is the syntax for cell A1
begin with 139 and have the rest of the numerical
placements as wild cards? This is a large spreadsheet and
I need to product to be different if cell a1 begins with
139 and column C=7956. Any help would be appreciated
 
=IF(C734=7905,D734*0.5,IF(C734=7925,D734*0.52,IF
(C734=7935,D734*0.8,IF(C734=7941,D734*0.6,IF
(C734=1170,D734*0.8,IF(C734=7956+AND
(a1=139068079),D734*0.8,d734*.7))))))

In the "and" statement, what is the syntax for cell A1
begin with 139 and have the rest of the numerical
placements as wild cards? This is a large spreadsheet and
I need to product to be different if cell a1 begins with
139 and column C=7956. Any help would be appreciated
Click to expand...

Would the number beginning with 139 always be 9 digits? If so, try

AND(C734=7956,INT(A1/1000000)=139)

If not, try

AND(C734=7956,LEFT(A1,3)="139")
 
Back
Top