Results 1 to 7 of 7

Boolean racking my brain

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2008
    Location
    Wilmington
    Posts
    26

    Boolean racking my brain

    Ok guys i need someone that can think through this boolean logically. its been a long day at work and now I'm trying to walk through this boolean thing to make sure my data will post on the right pages.

    I have an Excel Macro that will capture inputted customer/vehicle data from an input screen, at the end, based on questions answered, i need to place that data on 1 of 4 sheets in my excel document.

    The questions are:
    Is this a Nationwide claim? (Y.N) (boolean = nw)
    Is the vehicle here? (Y/N) (boolean = vh)

    So here's what i got
    if NW = true and VH = True then place data on "sheet1"
    if NW = true and VH = False then place data on "Sheet2"
    if NW = False and VH = true then place data on "sheet 3"
    if NW = false and VH = False then place data on "sheet4"

    I can't think of how to write this IF statement for this to happen. can't get the logic going.

    OR IS THERE A BETTER WAY?? i'm sure there is....

    Thanks to those who took time to read all this post
    Last edited by eighty2scrambler; 11-11-2008 at 07:09 PM. Reason: Thanks!

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