Hi mohitdawar,

Welcome to the forum.

The purpose of the forum is to assist people who are having trouble doing their own work in MS. Have a thorough read of the MS Users Manual and download the free Equis Formula Primer from the files section. These will give you the basics for writing your on MS functions, experts and explorations. Should you get stuck, you can always post your best attempt at the code on the forum, along with a full explanation of what you are trying to achieve and why your code is not achieving this, and someone will come to your aid.

There are also many, many posts containing codes which could already solve your problem. Do a search of the forum and see what comes up. Even if you don't find the exact answer, you might find something that's pretty close and can be edited to fulfil your specific requirements.


Hope this helps.

wabbit [:D]

a2:=If((L<a1) and (H>a1) and (C>a1),1,0);

Just add '=' also,

a2:= If((L<= a1) and (H>= a1) and (C>a1),1,0);