If statement help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

STEVEB - 30 Nov 2005 17:07 GMT

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.

Signature

STEVEB

Reply to this Message

bpeltzer - 30 Nov 2005 17:31 GMT

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

> Hi,
>
[quoted text clipped - 9 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

STEVEB - 30 Nov 2005 19:21 GMT

Thanks for your help! The formula worked great!

Signature

STEVEB

Reply to this Message