IF formula

S

Shaunp

Joined
Jan 3, 2014
Messages
2
Reaction score
0
Hi, sorry this is my first time posting. but im having a fair bit of trouble with a IF formula..

I have a got a membership excel document and i need to match up the prices to a certain membership. So column E has the prices and column O is where the membership type will be.

i know this is not working becuase the value true and value false are not at the end, but i have multiple values sadly.

=IF(AND((E2=368,"GYM 12","ERROR"),(E2=503,"GYM+GROUP 12","ERROR"),(E2=577,"CENTRE 12","ERROR"))
 
S

Shaunp

Joined
Jan 3, 2014
Messages
2
Reaction score
0
Well fate have it as soon as i posted this i worked it out!

=IF(E4=368,"GYM 12",IF(E4=503,"GYM+GROUP 12",IF(E4=577,"CENTRE 12","ERROR")))

Thank you all and sorry if i wasted anyone's time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Percentage Formula 4
range label works in VLOOKUP except if refenced in another cell 3
Currency formula 7
IF in formula 1
Logical if more than 7 4
Help with VLOOKUP & MATCH formula 5
IF and dates 7

Top