AND function

[mallik]

HI,
I try to pass use AND function like

AND(a,b) -- where a and b are arbitary values.
The retun value is ''bad index''. How Can i get null value or zero in this case.

MALLIK

[Administrator]

What do you mean by arbitrary values? What did you try to enter?

In our C:\Program Files\Syncfusion\Essential Studio\3.0.1.0\Windows\Grid.Windows\Samples\In Depth\FormulaValueTest sample,
you can type
,Code>
=And(1,0)

in a cell and get a result or false. You can also type

=and(A3=A4, A4=A5) 

and get the proper value. Exactly what are you trying to place in the argument list. The argument should be 1 or more well-formed expressions. If one of teh expressions in the list is a numerical expression, then if the value is exactly zero, it is treated as a false for teh AND, and if it is non-zero it is treated as a true.

[mallik]

The way you suggested is working fine.