Forum Discussion

Pairis's avatar
Pairis
Copper Contributor
Feb 29, 2020

Please help with a formula

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!

 

excel

1 Reply

  • liverlarson's avatar
    liverlarson
    Brass Contributor
    Mar 01, 2020
    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.

Resources