Percentage Formula's

Kendal

I have a beneficiary nomination form I am asking employees to complete, I am giving them the option of 4 beneficiaries, but would like to be able to tally the total percentage amounts they input per beneficiary as they complete the form to a total of 100%.

So would be 4 fields/columns allowing percentage inputs, if they put 100% in the first one, then they would not be able to add to the other 3 fields, or if they put 80% in the first one, they would only be allowed 20% in the next 3 and so on up to 100% cap.

Does anyone have a formula I could use for this. Any help would really be appreciated.

Paul Newcome

You will not be able to restrict this on the form itself. The best we can do is evaluate after submission and flag either for follow-up or an automated update request.