another complex =IF question
It's called an "Array Constant"
From XL's Help file:
Items that an array constant can contain
· Array constants can contain numbers, text, logical values such as TRUE or
FALSE, or error values such as #N/A.
· Numbers in array constants can be in integer, decimal, or scientific
format.
· Text must be enclosed in double quotation marks, for example "Tuesday".
· You can use different types of values in the same array constant, for
example, {1,3,4;TRUE,FALSE,TRUE}.
· The values in an array constant must be constants, not formulas.
· Array constants cannot contain $ (dollar signs), parentheses, or %
(percent signs).
· Array constants cannot contain cell references.
· Array constants cannot contain columns or rows of unequal length.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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
|