Hi dolores,
could you please let me know the logic to get to 100, post other example,
will it be always PP

"Dolores Gomez" wrote:

I am trying to assign codes to one of my worksheets based on pricing. The
problem that I am running into is that the data that I am taking my
information has a range of pricing Example below

PRICE POINT/RANGE PP
$0.01 TO $1 PP0100

I need to have a formula that looks at "PRICE POINT/RANGE" and compare it to
a column that has pricing (i.e .95). This formula/function should give me
the "PP" code.