# Excel - IF Function Problem - Expert Solution

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

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.