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