**Question description:**

*This user has given permission to use the problem statement for this blog.*

I am having a problem completing my if function in a scorecard spreadsheet.

Solved by E. Q. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
16/10/2018 - 06:36

Hi…Welcome to Got It Pro. I see that your question is about fixing formulas.

Excelchat Expert
16/10/2018 - 06:36

I can help you with that problem.

Excelchat Expert
16/10/2018 - 06:36

Before we get started, this is a quick reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.

User
16/10/2018 - 06:36

ok thankyou

Excelchat Expert
16/10/2018 - 06:36

Would it be possible for you to share the file?

User
16/10/2018 - 06:37

yes sharing now

Excelchat Expert
16/10/2018 - 06:37

Thanks

User
16/10/2018 - 06:39

sorry how can i import document im just getting blank screen

Excelchat Expert
16/10/2018 - 06:39

Please use the paperclip icon on the right here in this chat window to upload your file.

User
16/10/2018 - 06:40

ok done

[Uploaded an Excel file]

Excelchat Expert
16/10/2018 - 06:41

Which cell are you trying the IF function and what is the logic to be used?

User
16/10/2018 - 06:43

in cell AH i wish to have a function that if the total of set 1 2 and 3 (h) is greater than (i) add a point and keep adding points for every win if that makes sense

Excelchat Expert
16/10/2018 - 06:44

You have a total of 4 games.

Excelchat Expert
16/10/2018 - 06:45

So do you mean to keep adding 1 if the the first set of totals is more than the later for all for games?

Excelchat Expert
16/10/2018 - 06:45

Say for the next game compare P5 and Q5 and so on...is that right?

User
16/10/2018 - 06:46

yes i think so,

User
16/10/2018 - 06:47

example jed and craig in cell d9 will play 3 games and the results will be in h6-8 and for every point they get i would like them to add up in AH

User
16/10/2018 - 06:48

sorry hard to explain

Excelchat Expert
16/10/2018 - 06:48

Please extend the time when it prompts as this may a little more time.

User
16/10/2018 - 06:48

ok

Excelchat Expert
16/10/2018 - 06:51

Are you able to view this preview screen on the right?

User
16/10/2018 - 06:52

yes i downloaded it

Excelchat Expert
16/10/2018 - 06:53

You do not have to download, its the same sheet that you sent me that I have pasted the data here.

Excelchat Expert
16/10/2018 - 06:54

I am trying to understand your logic and need help.

Excelchat Expert
16/10/2018 - 06:55

Under Team Name, you have the teams.

Excelchat Expert
16/10/2018 - 06:56

Then in row 9 you have the opponents team, is that right?

Excelchat Expert
16/10/2018 - 06:57

So for Jed/Greg, in the given scenerio, how many wins should show in AH and which cells in the data should determine that. I can then create a formula based on that.

Excelchat Expert
16/10/2018 - 06:59

Hi...are you with me?

Excelchat Expert
16/10/2018 - 07:02

Ok...let me create the formula based on my understanding. This will take few minutes. I will upload the file once done.

Excelchat Expert
16/10/2018 - 07:07

Please look at the formula in column AH.

[Uploaded an Excel file]

Excelchat Expert
16/10/2018 - 07:08

I have done the same IF function. I have added 3 IF statments with a + sign.

Excelchat Expert
16/10/2018 - 07:08

Hope this is what you wanted.

Excelchat Expert
16/10/2018 - 07:09

I have also replicated the same formula for Losses column AI, with the logic change to if column H is less than I and so on.

Excelchat Expert
16/10/2018 - 07:09

Please feel free to leave any comments or feedback.

Excelchat Expert
16/10/2018 - 07:09

Thanks for your time. Please do come back for any new question. You can now end this session. Have a great day ahead!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*