I have one of four chars displayed in any cell "f", "p", "m", "d",

If it is only 1 of those 4 letters, perhaps another option:

=MOD(2626912,CODE(A1)+1)

--
HTH :)
Dana DeLouis


"The IC Teacher" wrote in message
...
I have one of four chars displayed in any cell "f", "p", "m", "d", i wish
to
convert "f" to 0 "p" to 1 "m" to 2 and "d" to 3 then compare to a second
set
of cells.
The second set of cells value can also be "f", "p", "m", "d" which i need
to
convert to the same set of numbers.
i will then use autoformat in a third cell to determine if the second set
of
cells is higher in value than the first or lower in value


The Teacher