| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula - odd/even months and different names
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Sheetnames when names are Months | Excel Discussion (Misc queries) | |||
| Formula to ave. last 3 months | Excel Worksheet Functions | |||
| How to use months in formula. | Excel Worksheet Functions | |||
| need if formula for 12 months | Excel Worksheet Functions | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Threaded Mode
