jemimapuddleduck
New Member
- Joined
- Dec 10, 2018
- Messages
- 6
Hi all,
I'm creating a 'rewards' spreadsheet and have nailed all of the formulas I need, apart from one
I'm getting confused with the multiple conditions I need, and how to put it into a formula.
<tbody>
</tbody>
What I want to be able to calculate is this:
If Structure Level is '5', Reward = 0
If Number of Tasks Completed < minimum tasks required, reward=0
If Number of Tasks Completed > Minimum Tasks Required, Reward = Total Earned as a Team/Number of remaining cases
Hope that makes sense. Can anyone advise, please?
Thanks
I'm creating a 'rewards' spreadsheet and have nailed all of the formulas I need, apart from one
I'm getting confused with the multiple conditions I need, and how to put it into a formula.
A | B | C | D | |
1 | Rubies Earned | 1250 | ||
2 | Minimum Tasks Required | Number of Tasks Completed | Structure Level | Rubies Reward |
3 | 9 | 9 | 4 | |
4 | 9 | 12 | 4 | |
5 | 9 | 0 | 4 | |
6 | 10 | 17 | 5 | |
7 | 8 | 2 | 3 |
<tbody>
</tbody>
What I want to be able to calculate is this:
If Structure Level is '5', Reward = 0
If Number of Tasks Completed < minimum tasks required, reward=0
If Number of Tasks Completed > Minimum Tasks Required, Reward = Total Earned as a Team/Number of remaining cases
Hope that makes sense. Can anyone advise, please?
Thanks
Last edited by a moderator: