I want to calculate something if the content of the reference cell begins
with "PN"
I tried to use "if" formula as below ;
if A2=PN# or * but it did not work

I will be gled if somebody help me
thanks
timur

=IF(LEFT(A2,2)="PN",B2*3,"no way")
=IF(LEFT(A2,2)="PN",B2*3,"")

But IF is not needed if you can live with zero when there is no PN
=(LEFT(A2,2)="PN")*(B2*3)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Timur" <(E-Mail Removed)> wrote in message
news:349699B6-ADE8-4915-8DF9-(E-Mail Removed)...
>I want to calculate something if the content of the reference cell begins
> with "PN"
> I tried to use "if" formula as below ;
> if A2=PN# or * but it did not work
>
> I will be gled if somebody help me
> thanks
> timur

Sub timur()
v = Selection.Value
If Left(v, 2) = "PN" Then
MsgBox ("found PN")
End If
End Sub
--
Gary''s Student - gsnu200735


"Timur" wrote:

> I want to calculate something if the content of the reference cell begins
> with "PN"
> I tried to use "if" formula as below ;
> if A2=PN# or * but it did not work
>
> I will be gled if somebody help me
> thanks
> timur