You can't build a formula like that, and why would you?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Franz Verga" wrote in message
...
This is avery interesting formula, I never saw before such use of array in
an OR function...
As far you know it's possible to use this way to shorten such a formula:

=IF(AND(B1=5,B1<=10,something,something_else)

I've tried with this:

=IF(AND(B1&{"=","<="}&{5,10}),"*","")

but I have a #VALUE! as a result.



Nel post
*Ragdyer* ha scritto:

Try this in A1:

=IF(OR(B1={"X","Y","Z"}),"*","")



--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit !

--------------------------------------------------------------------------
-
"gimp" wrote in message
oups.com...
i was given the formula to use in cell A1 if cell b1 = x to make A1
either be blank if it said something other than x, or if it said x it
would generate an (*). now is there a formula that can be used in the
same senario if B1 had a series of possible values to generate a (*)
in cell A1?

thanks again

--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy