Feb 29 2020 08:39 AM
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!
Mar 01 2020 12:37 PM