+ Reply to Thread
Results 1 to 3 of 3

Formula to Show True False

  1. #1
    Registered User
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Formula to Show True False

    Hi Everyone.

    I hope someone can help me.

    I have attached a part of a worksheet used at work. It shows when an individual starts a course and when they finish the course.

    It also needs to record if individuals leave the course either before a 3 month period, between 3 and 6 months, between 6 months and a year or after a year. The relevent boxes need to show True or False relevent to when they left the course.

    I need formula's to show a return of True or False in Columns F,G,H and I when an end date is recorded in Column J. I have no knowledge of Excel formula's at all , Someone started on this but left and I'am stuck with what I have here

    Can anyone help at all.

    Thank You in advance
    Attached Files Attached Files
    Last edited by Ortz; 02-16-2012 at 03:25 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Formula to Show True False

    See attached

    Additionally, to help you understand. Look at this link

    http://www.techonthenet.com/excel/formulas/if.php

    and this one

    http://www.techonthenet.com/excel/formulas/and.php

    and this one

    http://www.techonthenet.com/excel/fo.../if_nested.php

    Good luck
    Attached Files Attached Files
    Last edited by alansidman; 02-16-2012 at 11:55 AM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Formula to Show True False

    Thanks alan

    That was very quick, cheers and many thanks for the help

    I'll start looking at those sites, thanks for the lead on those

    Ortz

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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