I have beat my head against the wall with this one. I really hope someone can help here. To Completely summarize what I am trying to do....
{
If it is Peter's pay-week, N4 equals Y1
If it is Casey's pay-week, N4 equals Y1 + Y2
}
-----------------------------------------------------------------...