multiple possible result in one cell...

D

doudou

Hi,
In a IF function, I want to do something like this::confused:
IF(D476="s OR v OR v1 OR vp OR h";tab!$B$8;tab!$B$9))
So, for certains results, it has to retrieve a data, for the others
another one.
Thanks for your help...
 
B

Biff

Hi!

Try this:

=IF(OR(D476={"s","v","v1","vp","h"}),tab!$B$8,tab!$B$9)

Replace the commas with semicolons if that's what you use as separator in
your version of Excel.

Biff
 
Top