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!
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!