Results 1 to 9 of 9

If formula support

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2015
    Location
    Newcastle England
    MS-Off Ver
    2010
    Posts
    29

    If formula support

    Hello

    I am a school teacher and I have a list of the children's birthday in Column A

    In column B I want to record their term of birth -

    If Column A contains either September, October, November, December I want column B to return - Aut

    If Column A contains either January, February, March, April I want column B to return - Spr

    If Column A contains either May, June, July, August I want column B to return - Sum

    I am not sure if I need to use a match index formula or an if formula

    I was hoping someone could help. The system I get the d.o.b. from is in the format that I have included in cell A.

    I have attached a sample excel page of what Column A looks like.

    Mark
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula support ignoring 0's
    By markhorsey in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2015, 06:51 AM
  2. Index Formula support
    By markhorsey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-12-2015, 05:12 PM
  3. Class does not support Automation or does not support expected interface
    By ccs_1981 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2015, 05:57 AM
  4. runtime 430 error- Class does not support Automation or does not support...
    By kimcole5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2012, 01:27 PM
  5. Excel 2007 formula support
    By rpasha0169 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-29-2011, 03:35 PM
  6. [SOLVED] formula support needed
    By Johnny D in forum Excel General
    Replies: 2
    Last Post: 11-11-2005, 08:50 PM
  7. Replies: 3
    Last Post: 09-08-2005, 12:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1