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.
Unfortunately, activation email could not send to your email. Please try again.

AND function

Thread ID:





27541 Apr 13,2005 11:22 PM Apr 15,2005 12:12 AM Windows Forms 2
Tags: GridControl
Asked On April 13, 2005 11:22 PM

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 [Syncfusion]
Replied On April 14, 2005 07:05 AM

What do you mean by arbitrary values? What did you try to enter? In our C:\Program Files\Syncfusion\Essential Studio\\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.

Replied On April 15, 2005 12:12 AM

The way you suggested is working fine.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.