Constraints - Need help returning a value due to multiple level of constraints

mmeier363

New Member
Joined
Sep 8, 2016
Messages
9
HELLO, Looking for some help!
I am attempting to set up an excell spread sheet to calculate my team members work loads. I am runniing into some issues. what i need to do is if a cell is given a value of an interger to return the full load value and if it is a "S" (shared value, 50% of the full value needs to be given to 2 team members that are next to each otherr) to give a 50% value. but the shared value has to show a error if there is not 2 team memberrs next to each other. example is team member 1 has to be on one side of the shared set and tam member 2 on the other side of the shared set. It needs to error if it get put inside one teammembers set ie. team member 1 on both sides of the shared set. And need this half value if 2 team member are next to each other to only calculate in the 2 Team members cells. I can get everything except fot it calculates the half value to all team members.


I have my current equation set as :
(c73=) =IF(AND(G17<>"S",$G17<>$C$63),0,(IF($G17=$C$63,$E17,IF(AND($G17="S",$G16=$G18-1),$F17,ERROR))))
But this brings back 1/2 values for all team members


Run down of example:
compute to cell c73
Here are the list of known constraints:
if g16<>c63 then 0 unless g16=S and g15 or g 17 =c63, otherwise =0
if g17 cell =1 then E17
if g17 = E then 0
(if g17= S then =f17) only if g16=(g18-1), othrwise =error
S=Share (each teeam member takes 50%, has to be between 2 team memberrs ie (TM 1) (share) (TM 2),CAN NOT BE (TM 1) (SHARE) (TM 1))
E= Empty space = 0

Maybe thinking making something in VBS
 

mmeier363

New Member
Joined
Sep 8, 2016
Messages
9
Forgot to add Cell C63 =1, in this column it will bring back all values for Team member 1 only
 

Forum statistics

Threads
1,085,586
Messages
5,384,592
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top