checking the content of a cell if it starts with certain character
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
|