IF formula - odd/even months and different names

A

agatha

Hi, I need to write a formula that shows different names for different
months. Like, in column A I will have months of the year and column B I will
have a scientist name. For “odd†months (Jan, Mar, May, Jul, Sep, Nov), I
want scientist A, for “even†months (Feb, Apr, Jun, Aug, Oct, Dec)I want
scientist B. I usually use IF formula, but I am lost on this one. How do I do
that? Thanks a lot!
 
J

Joel

You need to create a date value like 1 Jan 2008 to get the month number.
Then use the MOD function to get the even and odd months. there are a few
other methods that can accomplish the same results.

=IF(MOD(MONTH(DATEVALUE("1 "&A7&" "&YEAR(TODAY()))),2)=1,"Scientist
A","Scientist B")
 

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

Top