ANOTHER IF(AND Statement question

[Mister H]

Hi:

As per usual I can not wrap my tiny mind around an IF(AND statement.

Here is what I have been trying to get to work:

=IF(AND(LEFT(B2,10)="Customer N",B2=B1,"Delete","")

So:

IF the first 10 characters in B2 are "Customer N"
AND IF the VALUE of B2=B1
then mark as Delete otherwise leave the cell Blank

Where did I go wrong with my formula?

THANKS to anyone that can assist
Mark

 

[repairman615]

Hello,

Looks like a missing parentheses:

<TABLE style="WIDTH: 329pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=438><COLGROUP><COL style="WIDTH: 329pt; mso-width-source: userset; mso-width-alt: 7008" width=438><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; WIDTH: 329pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21 width=438>=IF(AND(LEFT(B2,10)="Customer N",B2=B1),"Delete","")


</TD></TR></TBODY></TABLE>

 

[Mister H]

THANKS repairman615. I had tried the parenthesis but I put it at the end

After trying the formula it is looking like I may have to expand it a little to capture more duplicates. Is there anyway that you know of to add an OR

If LEFT(B2,10)="Customer N" OR "Balance fo"

THANKS Again for your help. It is APPRECIATED

Take Care,
Mark

 

[repairman615]

Hi Mark,

Like this?

<TABLE style="WIDTH: 584pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=778><COLGROUP><COL style="WIDTH: 584pt; mso-width-source: userset; mso-width-alt: 12448" width=778><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; WIDTH: 584pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=21 width=778>=IF(OR(AND(LEFT(B2,10)="Customer N",B2=B1),AND(LEFT(B2,10)="Balance fo",B2=B1)),"Delete","")


</TD></TR></TBODY></TABLE>

 

[Mister H]

Hi repairman615

THANKS that seems to do the trick

Your help is VERY APPRECIATED...

Have an EXCELLENT night,

Mark

 

[repairman615]

...EXCELLENT night,

Mark

Spreadsheet users crack me up! ..., EXCEL-lent.

,
Jeff