Thread: =IF ..OR.. =IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default =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