=IF ..OR.. =IF
I'm not sure about what you want with the 'print g' and 'print j' syntax,
but try this.
=IF(NOT(OR(A1={"G","J"})),"print ERROR",IF(A1="G","print g","print j"))
HTH,
Paul
--
"yovation" wrote in message
oups.com...
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
|