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