Contraint and field calculation

Dear all,

I have this situation.

Cell A= total number of dogs
Cell B= total female’s dogs
In order to avoid error, i want to create a constraint which cannot allow to put in cell B value > to cell A.
In addition, I want to create a calculation field with cell C =( CellA-CellB)

Thanks for your help

Hard to be exact without knowing more about your structure but this sounds
like a pretty straightforward constraint on B:

. <= ${a}

and a calculation on c:

${a} - ${b}.

You can find out more about basic constraints and calculations here:

http://xlsform.org/#constraints
http://xlsform.org/#calculation

Jason

··· On Wednesday, November 16, 2016 at 2:01:45 PM UTC-5, norra...@gmail.com wrote: > > Dear all, > > I have this situation. > > Cell A= total number of dogs > Cell B= total female’s dogs > In order to avoid error, i want to create a constraint which cannot allow > to put in cell B value > to cell A. > In addition, I want to create a calculation field with cell C =( > CellA-CellB) > > Thanks for your help >