Results 1 to 9 of 9

IF Statement

Threaded View

garyrobbo IF Statement 06-10-2015, 06:02 AM
Glenn Kennedy Re: IF Statement 06-10-2015, 06:05 AM
garyrobbo Re: IF Statement 06-10-2015, 06:31 AM
jayajaya_4 Re: IF Statement 06-10-2015, 07:00 AM
Richard Buttrey Re: IF Statement 06-10-2015, 07:02 AM
garyrobbo Re: IF Statement 06-10-2015, 07:09 AM
garyrobbo Re: IF Statement 06-10-2015, 07:06 AM
cbatrody Re: IF Statement 06-10-2015, 07:06 AM
Glenn Kennedy Re: IF Statement 06-10-2015, 07:25 AM
  1. 06-10-2015, 06:02 AM #1
    garyrobbo is offline
    Registered User
    Join Date
    12-12-2014
    Location
    Liverpool
    MS-Off Ver
    Office 2010
    Posts
    13

    IF Statement

    Morning

    I have a class recording sheet that I want to use an IF statement with.

    Basically on the course the students are following they have to achieve the following grades:

    IF A2:C2 = P, then G2 = P
    IF A2:C2 = P and D2:E2 = M, then G2 = M
    IF A2:C2 = P and D2:E2 = M, and F2 = D, then G2 = D

    You have to achieve a pass and a merit in all areas to achieve a Distinction.

    I have attached a screenshot to help, if I have not made myself clear. Thanks in advance!!!
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. compile error expected line number statement end statement
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 10:12 AM
  2. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  3. [SOLVED] Convert If statement with cell row reference calculations to vlookup statement
    By excyclist in forum Excel General
    Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  4. VBA- Compile Error, Expected: line number or label or statement or end of statement
    By RLK7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  5. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1