Results 1 to 8 of 8

Help with tricky IF statement. Somewhat conditional.

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2004
    Posts
    14

    Help with tricky IF statement. Somewhat conditional.

    You guys have been so helpful, and I sure do appreciate everything you all have done to each me about Excel. Thanks.

    The formula in G14 is =B14. There will always be a value in B14. I only want G14 to equal B14 is there is a specific value in F6. If there is not the value that I want in F6, I want G14 to remain blank and not copy the contents of B14 into G14.

    For example:
    If F6=n12345 then G14 = B14.
    If F6=n567AB then G14 = B14.
    but,
    If F6=n6609K then G14 should not copy B14 and stay blank.
    or
    If F6=n145AB then G14 should not copy B14 and stay blank.

    As a test, I used this formula in G4, but had not luck at all:
    =IF(F6="n12345",=B14,"")

    There are maybe 5 nXXXXX that I would need this to happen for, so if 1 of these 5 values appear in F6, then I want G14 to equal the contents B14, all the while keeping the formula of G14 equaling B14. If there is is nothing in G14, I want the space to remain completely blank, no "0", no "#N/A", no nothing. As always, thanks in advance guys................

    mcr1
    Last edited by mcr1; 01-08-2006 at 12:18 AM.

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