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=1000 000,COUNT(J18:O18)=0),"G1",IF(AND(LEFT($B$7,3)="62 9",$B18=1000000,COUNT(J18:O18)<0),"G1/G2",IF(AND(LEFT($B$7,3)="629",$B18=100000,COUNT(J 18: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.


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=489477

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

"STEVEB" wrote:


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=1000 000,COUNT(J18:O18)=0),"G1",IF(AND(LEFT($B$7,3)="62 9",$B18=1000000,COUNT(J18:O18)<0),"G1/G2",IF(AND(LEFT($B$7,3)="629",$B18=100000,COUNT(J 18: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.


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=489477

Thanks for your help! The formula worked great!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=489477