"IF" formula - I am having problems with

[Pauls123]

Hi, I am new in this forum site, and having problems with an IF formula. I am wondering if such a formula may exist that would allow me to do the following. I have created an excel (2010) spreadsheet for horseracing that will allow me to rate every runner in a race out of 100. By copying and pasting data from an online formguide site, I have rated the last 3 races of every runner. Now I want to average each of those 3 runs. However I only want to average them if they are in the horse's current campaign.

So lets say that Column A has the rating figure/s for the horse/s third last start; Column B has the rating figure/s for the horse/s second last start and Column C, for the last start. I also have a Column D (details copied and pasted also) that tells me how many runs each horse has had, in its current campaign, it may say 4, 5, 3 or 7 etc. However if the horse is first up it will show "FU" and if the horse is second up (from a spell) it will show "SU".

What I would like is for Column E to show the average rating of the last 3 runs, providing the horse has had 3 runs in this campaign. Hence if the figure in Column D is 3 or more, I want Column E to show the average of Columns A, B and C. If the figure in Column D is 2, I want Column E to show the average of Columns B and C. If the figure in Column D is "SU", I just want Column E to show the rating in Column C. If the figure in Column D is "FU", then maybe Column E can just show that, "FU".

The final thing I would like is that if cells A, B and C are blank, say due to not having a runner there, then I would want say cell E2 to be also blank.

I hope you can follow this, Regards, Paul

[zbor]

I would rather suggest you to focus on the problem and upload example workbook.
For that

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.

[DominicJ]

My suggestion would be calculate all three averages, and then use an if statement to select which one you want.

So E, F and G are your three averages, two of which are rubbish, then something like

H1=IF(D1="FU",E1,If(D1="SU",F1),G1)