+ Reply to Thread
Results 1 to 3 of 3

If statement based on various cell criteria

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    If statement based on various cell criteria

    Hi,

    I have three cells:

    G5 - can contain True or false
    G6 - contains text but the if is on the basis of this cell being "Hand Delivered" or not

    I have tried the following to illustrate what I after:

    Please Login or Register  to view this content.
    It speaks for itself but my formula is rubbish!:

    IF G5=FALSE,"Letter Not Required"
    IF G5=TRUE AND G6="Hand Delivered Letter) then show "Letter Delivered"
    IF G5=TRUE,"Letter Required"
    There should be no else so blank will do.

    Hope someone can help. Thank you in advance.
    Last edited by jpruffle; 08-12-2009 at 05:00 PM.

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: If statement based on various cell criteria

    Try...

    =IF(G5=FALSE,"Letter Not Required",IF(AND(G5=TRUE,G6="Hand Delivered Letter"),"Letter Delivered",IF(G5=TRUE,"Letter Required","")))

  3. #3
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Re: If statement based on various cell criteria

    Thanks works great!

+ 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