=IF ..OR.. =IF

[yovation]

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

 

[PCLIVE]

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

 

[Brian Withun]

=IF(A1="G",g,IF(A1="J",j,"ERROR"))


this presupposes that g and j are defined to be something, otherwise
you'll just get a #NAME? error

Brian Herbert Withun

 

[Trevor Shuttleworth]

Some options:

=IF(A1="G","G",IF(A1="J", "J","ERROR"))

=IF(A1="G",A1,IF(A1="J", A1,"ERROR"))

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

Regards

Trevor

 

[JE McGimpsey]

One way:

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

Or, if case doesn't matter:

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

 

[yovation]

Thank you.

=IF(A1="G","G",IF(A1="J", "J","ERROR"))

works great.

David

 

[Trevor Shuttleworth]

You're welcome. Thanks for the feedback

Regards

Trevor

 

[Guest]

=IF(A1="G","Print g",IF(A1="J","Print j","Print 'ERROR"))