Hi folks,

I have a spreadsheet with the following kind of entries

A B C

Bob 1 0.5 0.5
John 2 0 0
Linda 0 1 1


I need to know how to restrict the maximum value that can be keyed under A,B
& C for each person, so that no cell can have an answer greater than 2, and
the sum total of A,B & C for each person cannot be any more than 2 either.

I'm pretty new to this, so I may be missing something blindingly simple.