elwayisgod
asked on
Excel Formula Help
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.
2018_Fantasy_Football_Standings.xlsx
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.
2018_Fantasy_Football_Standings.xlsx
You know you're creating a circular reference?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yep. Got a circular reference error.
I didn't get the circular reference because I tested the formula in column W.
Circular reference is there because of the formula in W3 and W4.
If you place the overwrite the column V with suggested formula, in that case W3 is dependent on V27 which in turn is dependent on V18:V25 and w4 is dependent on W3 and that creates the circular reference.
Circular reference is there because of the formula in W3 and W4.
If you place the overwrite the column V with suggested formula, in that case W3 is dependent on V27 which in turn is dependent on V18:V25 and w4 is dependent on W3 and that creates the circular reference.
ASKER
Works perfectly. Thanks, I would have never thought of this.
If in that case you want simply the exact value from column T, try the below formula otherwise if you want blank in else case, just replace the bold part T18 with "" (two double quotes).
In V18
=IF(ISNUMBER(MATCH(INDEX($
Open in new window