if formula

[HVK1986]

Hi everbody,


Pls suggest a suitable formula for me for the below data.


If in A1 the data is honda/mahindra/audi/benz(any 1 out of 4) in b1 the data should automatically come as "good cars".


If the data in A1 is other than those 4, in B1 the data should be displayed as "will be examined"


Pls guide

Regards,

harry

 

[Hui]

Harry


=If(or(A1="honda",A1="mahindra",A1="audi",A1="benz"),"Good Car", "Will be examined")

 

[HVK1986]

thank u sir hui...

 

[Luke M]

Another way of writing the same thing, but slightly shorter:

=IF(OR(A1={"honda","mahindra","audi","benz"}),"Good Car","Will be examined")

 

[HVK1986]

thank u luke M .......

 

[SirJB7]

@HARRY

Hi!

If I were you I'd only use this formula:

=IF(User="SirJB7","1.benz, "&"2.audi, "&"3.honda",IF(OR(User="Hui",User="Luke M"),"rickshaw","mahindra")



Regards!

 

[Luke M]

@SirJB7

ROFL! Thanks for the smile.

 

[bobhc]

SirJB7 good evening my friend


You left out shanks pony!

 

[SirJB7]

@Luke M

Hi, buddy!

Only for the smile?

Regards!


@b(ut)ob(ut)hc

Hi!

Good afternoon, my friend.

I tried to not get them so tired as to wouldn't be able to post here.

Regards!

PS: I must recongize that I had to google shanks pony...