Need Help using and understanding IF function

**isixes27ce** · 11-07-2012, 08:57 PM

I have a workbook that I am running for a fantasy league of mine.
I need help connecting and using the IF function for the "Step 2" and "Step 3" worksheets.

For example, in "Step 3"
IF "Darius Rider" is seen anywhere in C3:C95 or H3:H95 of "Step 2" worksheet, and he has value of -3,-2,-1,1,2,3 in on his record in column D or column I beside his name...how do add that value to his OVR in column D2 of worksheet "Step 3"

Also If "Darius Rider is seen anywhere in R4:28 in "Step 2" worksheet how do I make column C...the unit that is attached to his name, which is part of his record..say "40"

I have attached the worksheet. Any help will be appreciated

**protonLeah** · 11-07-2012, 10:56 PM

Part I: In Team Change Report (Step 3) cell D2 and copied down:

Please Login or Register  to view this content.

Note that since I didn't know if there are other values beside -3 ... +3, I used the CHOOSE function and added 4, to find the number in the list to add to the score.

I don't understand your "Also, if..." part.

**isixes27ce** · 11-08-2012, 01:55 PM

Thanks so much!!!!! But I'm still having trouble applying it. I forgot to mention that I wanted to include to the 95th row. So I put that in the formula. As I will be applying this to many cells in "Step 3" B2:B37, I2:I39, and P2:P13.

Please Login or Register  to view this content.

My issue now is I don't know how to calculate the sum of the score. If for example "Darius Rider" appears twice in either the column of Progression Journal or Regression Journal, it will not take the sum the total values. It will only take the first value in which his name appears first and ignore any future values when his name is placed again in that column.

I also don't know how to work on formula to account for M3:M29 in "Step 2" worksheet.
If a player name shows anywhere in M3:M29 and has a value of -3,-2,-1,0,1,2,3 or any value next to him in column N
how do I get column F and column N to show the value ADDED to whatever OVR is in D or K. This formula is not as important but I'm working on it.

To clearify in "Step 3" column B is offensive players
column I is defensive players
and column P is special teams....

I uploaded what I have done so far. I applied the formula to the necessary cells.

**isixes27ce** · 11-08-2012, 08:26 PM

ease??Help?? Anyone???P

**isixes27ce** · 11-09-2012, 03:41 PM

Anyone?? I'm really struggling.

How do I get the formula to count the multiple values of each column if a player name appears more than once in a column?

**jeffreybrown** · 11-09-2012, 04:16 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.