Skip to Content
0
Former Member
Jul 01, 2009 at 03:51 PM

Using "and" in a condition formula

26 Views

Is there anything wrong with this? If my "If" condition only contains one of the fields, things work fine, but using the "and" with two fields doesn't seem to work. I am probably writing this wrong, but it returns no errors. Also I cannot seem to find any set of rules for using "and", any hard rules I should know?

If IsNull ({#RTotal0}) and IsNull ({#RTotal1}) Then

{#RTotal2} + {Cabinets.CustomPrice}

Else

{#RTotal0} + {#RTotal1} + {#RTotal2} + {Cabinets.CustomPrice}

Thanks for the help,

Mike