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
>