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.
