Hi,

I think he wants it blank if not PMC or PLB.


Cheers,
Shane Devenshire


"T. Valko" wrote:

Try one of these:

=C1+IF(LEFT(A1,3)="PMC",120,IF(LEFT(A1,3)="PLB",60 ,0))

=C1+(LEFT(A1,3)="PMC")*120+(LEFT(A1,3)="PLB")*60

--
Biff
Microsoft Excel MVP


"RYNNER" wrote in message
...
here is the sample of my formula, this is what im tryin to say =IF(A1=PMC
1234,C1+120,"",IF(A1=PLB 1234,C1+60,""). this is the prob, PMC or PLB is
not
constant, it is always followed by different numbers, if i use PMC, it is
plus 120, if PLB, it is plus 60.. im tryin to replace it with asterisk,
therefore =IF(A1=PMC*,C1+120,"",IF(A1=PLB*,C1+60,""). but it doesnt
work... i
hope someone understand my problem...
thanks

rynner