One way:

=IF(OR(EXACT(A1,{"G","J"})),LOWER(A1),"ERROR")

Or, if case doesn't matter:

=IF(OR(A1={"G","J"}),A1,"ERROR")

In article .com,
yovation wrote:

Hi,

I'm trying to create a formula that will do this:

=IF(A1="G",print g,) or =IF(A1="J", print j,) =If(A1 = anything other
than 'G' or 'J', print 'ERROR")

Will someone help me with this. I am drawing a blank...

Thank you.
Yovation