Results 1 to 3 of 3
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with =IF statement (Excel 2003)

    It depends on exactly what you want to do. If you want to check if D4 is equal to "X", then you could use:

    <code>
    =IF(D4="X",$G$257,"")
    </code>

    If you want to check if D4 is not empty, then you could use:

    <code>
    =IF(D4<>"",$G$257,"")
    </code>
    Legare Coleman

  2. #2
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Edgecomb, Maine
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with =IF statement (Excel 2003)

    Edited by HansV to present data in table format

    Hi All,

    I'm setting up a training tracking spreadsheet, and need it to be simple. I have column A with first name, B with last name, C with 'Classification, and D with "Present?", and E is the topic name (Date given is to populate in the cells below).

    <table border=1><td></td><td align=center>A</td><td align=center>B</td><td align=center>C</td><td align=center>D</td><td align=center>E</td><td align=center>1</td><td>Joe</td><td>Smith</td><td>D</td><td>X</td><td align=right>March 25, 2006</td><tr><td align=center>2</td><td>Jane</td><td>Public</td><td>D</td><td align=right>

  3. #3
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Edgecomb, Maine
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with =IF statement (Excel 2003)

    Thanks for the quick reply. The first example is the one that works for me. I need to keep data entry by the instructors simple, and this does it.

    Have a great day,

    --Jim

Posting Permissions

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