Formula per value in cell

[rizmomin]

Hello:

Please refer to attached file.
I need a formula in C1 as follows
If A1 is Apr,Jun,Sep or Dec then C1 = Q otherwise C1 = M


Let me know if you have any questions.
Thanks.
RM

[LeoTaxi]

In C1

Please Login or Register  to view this content.

Kind regards
Leo

[LeoTaxi]

In C1

Please Login or Register  to view this content.

Kind regards
Leo

[Quasis]

This is a slightly easier one

Please Login or Register  to view this content.

This uses the OR function as you want to return true if A1 equals Apr, Sep, or Dec. the IF is so that it will give you the ability to return Q or M and I've put the area in an array constant so that it'll work.

This one goes right back to basics

Please Login or Register  to view this content.

[rizmomin]

Hi LeoTaxi:

Thanks a lot.
Works great.
RM