is it you look for?

=if(A1="U","Failed","Passing")


"DOUG ECKERT" wrote:

I want to code scores "E" and "S" as passing and "U" as not passing. Scores
are in a table of months arranged horizontally. Suggestions are welcome.

DOUG