Adding up percentages
Hello David,
The problem is that I do not have a formula, that is why I am seeking your
help. I am sorry if I haven;'t been clear enough!.
Kind regards,
Jay
"David Biddulph" wrote:
Well, you haven't told us what formula you are using for adding the
percentages, but try =MIN(your_formula,1) or =MIN(your_formula,100%) ?
--
David Biddulph
"The Fool on the Hill" wrote in
message ...
Dear Excel(lent) users,
I want to add up percentages:
I have 4 columns (A, B, C, D). In
A: Name of a person (selectable from validation list)
B: Percentage
C: Name of a person (selectable from validation list, same list as A)
D: Percentage
You can select a person and add a percentage. This means that one person
can
be selected multiple times.
I know want to control, that one person is not going to exceed 100%. Is
there some formula for this?
Thanks for helping me out !
Kind regards,
Jay
|