In the cells V18 to V25, I need a formula that is the value in T18 to T25 for each player. But I need to add logic:
If player rank is '1' in W7 to W14 then add (.5 * W4)
If player rank is '2' in W7 to W14 then add (.3 * W4)
If player rank is '2' in W7 to W14 then add (.2 * W4)
The value in W4 continues to shrink as each week goes on. That's OK, just a way it's setup. At the end it should be $490 that gets allocated out.
Thanks in advance, not quite sure how to do this.