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
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,961
Messages
5,599,061
Members
414,281
Latest member
Engjamal2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top