Please help with a formula

Copper Contributor

Hello Everyone, 

 

I am in need of some formula help! 

 

I'm building a roster for my team. We have the following functions:

 

MD = ModerorDay

MA = ModeratorEvening 

BD = BackendDay

MW = ModeratorWeekend

Vrij = Free

% = Extra day of for partimers

 

 

I want Excel to calculate that 1 MD and 1 MA = 0 (since that is the minimun required) 

So how do I give MD and MA the value of 0? And Vrij and % the value of -1? Or Am I looking in the wrong direction?

 

Thanks for the support!

Pairis_1-1582993990746.png

 

1 Reply
I believe you are not getting responses because of a lack of information. In your screenshot, where is the formula? What is it showing with your current attempt, and what would you expect it to show? (note that in your screen shot, rows and columns are not even visible, so it will be hard to reference that image in terms of cell D8 should be showing XXX. You may want to provide a different attachment for additional context.