Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc