If statement help

  • Thread starter Thread starter STEVEB
  • Start date Start date
S

STEVEB

Hi,

Does anyone have any sugesstions for the following:

I have the following formula that looks at the first three digits in
cell B18 and enters a various code based on certain situations.

=IF(ISNA($B$7),"",IF(AND(LEFT($B$7,3)="122",$B18>=1000000),"G3",IF(AND(LEFT($B$7,3)="629",$B18>=1000000,COUNT(J18:O18)=0),"G1",IF(AND(LEFT($B$7,3)="629",$B18>=1000000,COUNT(J18:O18)<>0),"G1/G2",IF(AND(LEFT($B$7,3)="629",$B18>=100000,COUNT(J18:O18)<>0),"G2","")))))

I would like the formula to include "630" & "631" wherever "629" is
referenced in the formula.

Any help would be greatly appreciated.
 
Replace LEFT($B$7,3)="629"
with OR(left($b$7,3)="629",left($b$7,3)="630",left($b$7,3)="631")
HTH. --Bruce
 
Back
Top