And or problem

[arytxer]

Hello,

I want to do a formula that gives the results below.

IF:
OWE102 does not have a letter or -1 after it and the invoice number begins with a P or 2 or S or L then the result would be 15
OWE102 does not have a letter or -1 after it and the invoice number begins with a C or B then the result would be 30
OWE102 does have a letter or -1 after it and regardless of the invoice number then the result would be 0

At present the formula returns the result of 0 or value as seen below.

IF(OR(RIGHT(A3,2)="-1",CODE(RIGHT(A3,1))>=65),"")*IF(LEFT(B3,1)="2","15",IF(LEFT(B3,1)="S","15",IF(LEFT(B3,1)="P","15",IF(LEFT(B3,1)="C","30",IF(LEFT(B3,1)="B","30",IF(LEFT(B3,1)="L","15"))))))

OWE102 P0000 0 15
OWE102 26200 0 15
OWE102 S36200 0 15
OWE102 L0000 0 15
OWE102 C0000 0 30
OWE102 B16200 0 30

OWE102A P0000 #VALUE! 0
OWE102A-1 26200 #VALUE! 0
OWE102B S36200 #VALUE! 0
OWE102B-1 C0000 #VALUE! 0
OWE102C B16200 #VALUE! 0

[martindwilson]

try
=IF(AND(ISNUMBER(RIGHT(A1,3)+0),OR(LEFT(B1)={"p","2","s","l"})),15,IF(AND(ISNUMBER(RIGHT(A1,3)+0),OR(LEFT(B1)={"c","b"})),30,0))

[arytxer]

Oooooooooooooooo you star. fixed first time thank you soooooooooo much.