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
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
In C1
Kind regardsPlease Login or Register to view this content.
Leo
Last edited by LeoTaxi; 10-11-2015 at 12:38 PM.
In C1
Kind regardsPlease Login or Register to view this content.
Leo
Last edited by LeoTaxi; 10-11-2015 at 12:39 PM.
This is a slightly easier one
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.Please Login or Register to view this content.
This one goes right back to basics
Please Login or Register to view this content.
Last edited by Quasis; 10-11-2015 at 12:57 PM.
Hi LeoTaxi:
Thanks a lot.
Works great.
RM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks