Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula where if Column D = a particular membership level, Column C will = the number of tickets. Example - Column D = Silver Membership, therefore Column C will = 2 Seats.
Solved by E. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/06/2018 - 03:43
Hi! how are you! welcome to Go it Pro!
User
20/06/2018 - 03:44
hi
Excelchat Expert
20/06/2018 - 03:44
Thank you for the question you've posted! It seems you ara having a problem with creating a formula
User
20/06/2018 - 03:44
yes
Excelchat Expert
20/06/2018 - 03:44
Don't worry I will help you
User
20/06/2018 - 03:45
Thank you
Excelchat Expert
20/06/2018 - 03:45
I want to make sure I understand your question
Excelchat Expert
20/06/2018 - 03:45
depending on the value that is in column D you want a result on Column C
Excelchat Expert
20/06/2018 - 03:46
s that right?
Excelchat Expert
20/06/2018 - 03:46
is that right?
User
20/06/2018 - 03:46
Yes that's correct
Excelchat Expert
20/06/2018 - 03:46
ok, what are the memberships that you would have on the column D?
User
20/06/2018 - 03:48
Bronze Silver and Gold
Excelchat Expert
20/06/2018 - 03:49
Ok and please, tell me what are the results that you want to obtain en column C for each membership?
User
20/06/2018 - 03:49
2, 4 6
User
20/06/2018 - 03:49
Sorry! 2, 4 and 6
Excelchat Expert
20/06/2018 - 03:50
ok, then I will explain you how to do this
Excelchat Expert
20/06/2018 - 03:50
there is a function called "IF" its a conditional that gives u a result, depending of a logical comparison
User
20/06/2018 - 03:51
Yes! I was on the right track I just couldn't work out how to use it!
Excelchat Expert
20/06/2018 - 03:51
for example, IF membership is bronze, give me 2
Excelchat Expert
20/06/2018 - 03:51
look how I do it
User
20/06/2018 - 03:52
Ok
Excelchat Expert
20/06/2018 - 03:53
so look at ther formula
User
20/06/2018 - 03:53
This is great. Thank you
Excelchat Expert
20/06/2018 - 03:53
Let me explain exactly what I did
Excelchat Expert
20/06/2018 - 03:53
I concatenated 3 IFs
Excelchat Expert
20/06/2018 - 03:54
the variables of the IF function are (Logical test, value if yes, value if no)
Excelchat Expert
20/06/2018 - 03:55
so what I did was, If bronze then give me 2, if silver give me 4 and if gold, give me 6, adn if nothing give me "empty"
Excelchat Expert
20/06/2018 - 03:56
if you see at the enf of the formula there is a ""
Excelchat Expert
20/06/2018 - 03:56
that means that if column D there is nothing, the it gives you empty
Excelchat Expert
20/06/2018 - 03:56
so, let's try the result
User
20/06/2018 - 03:57
This is perfect thank you
Excelchat Expert
20/06/2018 - 03:57
Now that I've provided you with the solution, does that fully address your question?
User
20/06/2018 - 03:57
Can that be applied if there are more than 3 memberships?
User
20/06/2018 - 03:57
Do you just carry them on?
Excelchat Expert
20/06/2018 - 03:57
in that case, you have to apply a ni IF there is the ""
Excelchat Expert
20/06/2018 - 03:57
example
User
20/06/2018 - 03:58
Actually i have just applied with a 4th membership
User
20/06/2018 - 03:58
And have made it work. This has been so great, and easy! Thank you!!
Excelchat Expert
20/06/2018 - 03:59
I'm glad I could answer your question today. Please visit Got It Pro again!
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.