We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

AND function

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

2 Replies

AD Administrator Syncfusion Team April 14, 2005 11:05 AM UTC

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.


MA mallik April 15, 2005 04:12 AM UTC

The way you suggested is working fine.

Loader.
Up arrow icon