6 Replies Latest reply: Mar 15, 2010 10:03 AM by Peggy
Level 1
profit for "D" and "M" based on how much of the project they were directly involved with.

I don't know how to show you the screenshot of the SS other than this.... http://files.me.com/dbrandt6/6v4jtu

What I would like as the end result:
1. if "D" is checked in column B, then "D" in column G would have a percentage amount assigned to it... (column E)
2. same thing for "M" in column C
3. if BOTH "D" and "M" are checked, then both "D" and "M" in columns G & H would get 1/2 of the percentage amount in column E.
4. if NEITHER are checked, then columns G & H would be zero.

The sum of column E (E27) will always equal 100%. Only the rows that have a check mark will be assigned a percentage. The percentage of a "check marked" row (column E) would be calculated based on the total number of rows that are "checked" ... always totaling 100% (E27). i.e. There are a total of 25 rows. If only 18 rows have check marks, (and row 4 will ALWAYS be checked... and equal 10%), then 100%-10%/18 tasks "checked"=5%. This 5% will show up in column E in the "check marked" rows.

The total percentage of column G.... added to column H would also equal 100%.

Thank you for your inputs..... Cheers... Doug

2.0 GHz Intel Core 2 Duo Mac Mini, MBP Duo, iPhone 3.1, Mac OS X (10.6)
• Level 1
in both cases of "both boxes checked" or "both boxes UNchecked", that the assigned profit percentage just be split between "D" and "M" evenly. The 'financial' result would be the same with fewer formulas.

Just a thought.
• Level 6