Validating sum of 2 cells, same row

[jgkocis]

Hi-

I have created a row with 2 categories and 2 numerical selection lists
The numerical selection list represents a % allocation and goes fro
0-100 in increments of 5 and the goal is to apply a percent of tim
spent on activities in each category. The sum of the two %allocatio
cells should equal 100 - is there a way to confirm/validate this befor
the user leaves the row??

eg

Row 1 Category 1 %allocation Category2
%allocation
Row 2 Activity 1 0-100 (selection list) Activity 2
0-100(selection list)


Thanks

-Ji

 

[Trevor Shuttleworth]

Jim

I don't really see the point of validating it ... or even putting in two
percentages. If you've only got two things to choose from and you spend x%
of your time doing one of them, you must spend (100-x)% of your time doing
the other one. By validating, you're just trying to force people to put
50/50 or 40/60 or 30/70 or whatever.

Am I missing something ?

Regards

Trevor

 

[jgkocis]

There are actually 4 categories and selections, but for brevity just
explained it as 2