Results 1 to 2 of 2

Thread: If Statements in VBA

  1. #1

    If Statements in VBA



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have the attached spreadsheet where I am trying to use the if Statement based on the following:

    - From Column I: If Column I is "NO" then Column I="No interval found" for each row of the spreadsheet and Column J,K,L must be blank (" ")

    - Or From the the same Column I: If Column I is "PDM" then Column I= "PDM (but No interval found)" and Column J,K,L must be blank (" ")


    Please see the tab called "Results Desired" to understand what I am talking about.

    Thanks in advance

    Michael
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,810
    Articles
    0
    Excel Version
    365
    cross posted at http://www.vbaexpress.com/forum/show...VBA&highlight=
    Micheal1974, please read http://www.excelguru.ca/content.php?184
    Ultimately it's for your own benefit.

Posting Permissions

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