+ Reply to Thread
Results 1 to 5 of 5

Skip, ignore or miss false value

Hybrid View

  1. #1
    Registered User
    Join Date
    01-14-2020
    Location
    Murcia, Spain
    MS-Off Ver
    2013
    Posts
    6

    Skip, ignore or miss false value

    I am looking to copy data from one cell to another, only if something is true. If it is false I want it to ignore the false side of things and not leave a blank cell, or put a zero or false. Just to leave the cell as is (as the cell will have data in already that I don't want overwritten.

    Please see the attached file.
    If any false HAS to be written, could it then write the false output to the blank cell to the right of it?

    (Apologies if this has been answered before, I've searched and searched and couldn't find just what I was after, or adjust previous similar results to work for this scenario)
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Skip, ignore or miss false value

    as I see there is another condition
    d2 =IF(B1="variable";C1;"")

  3. #3
    Registered User
    Join Date
    01-14-2020
    Location
    Murcia, Spain
    MS-Off Ver
    2013
    Posts
    6

    Re: Skip, ignore or miss false value

    Quote Originally Posted by BMV View Post
    as I see there is another condition
    d2 =IF(B1="variable";C1;"")
    Hi BMV, yes that's correct.
    This is a very small part of csv for a website.

    It is for products that are either "simple" - just buying as is or as "variable" where you can buy either a t-shirt in red, green, blue with sizes S, M, L. I need to put the parent product (column D) in for all the variations.
    That means I need to pick up the product code (C1) when "variable" is in B1 and then put that into all the variations for that product, in this case into D2, D3 and D4.

    One issue is, that when I have "variable" then the "variations" for it can differ from a few to many, hence trying to first copy over from C1 to D2, then after that copy D2 down for each following variation.

  4. #4
    Forum Contributor shank_mis's Avatar
    Join Date
    09-08-2018
    Location
    Delhi
    MS-Off Ver
    2010
    Posts
    128

    Re: Skip, ignore or miss false value

    Referring to your sheet, you cannot write formula in column D otherwise you will loose data in stored in that column. I hope that's obvious to you.
    In column E, you can write formula and this column would yield final result.

    In Cell E2: =IF(AND(D2="",B2="variation"),E1,D2) and drag the formula down to the end.
    This would give you desired result. You can hide column D or keep it whatever you like.
    Last edited by shank_mis; 01-15-2020 at 04:59 AM. Reason: correction
    Shashank Mishra
    Please hit "Add Reputation" Button if you liked the answer.

  5. #5
    Registered User
    Join Date
    01-14-2020
    Location
    Murcia, Spain
    MS-Off Ver
    2013
    Posts
    6

    Re: Skip, ignore or miss false value

    Quote Originally Posted by shank_mis View Post
    Referring to your sheet, you cannot write formula in column D otherwise you will loose data in stored in that column. I hope that's obvious to you.
    In column E, you can write formula and this column would yield final result.

    In Cell E2: =IF(AND(D2="",B2="variation"),E1,D2) and drag the formula down to the end.
    This would give you desired result. You can hide column D or keep it whatever you like.

    Hi Shank_mis,

    This is my first proper time of using functions so, no it wasn't obvious that I couldn't put formulas into column D. I've done basic maths formulas but never needed to do something as complex as this. I was hoping that there was a way that an IF function could have its' false value ignored or use another function that only gives out true values.

    However, your formula works a treat. I can use that and then copy the contents from column E into D as visual data. Perfect. Thank you SO much. Really appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If statement is false, skip to next row
    By tbraden in forum Excel General
    Replies: 3
    Last Post: 12-18-2018, 10:34 AM
  2. IF function (IF False skip to next row)
    By FatmaMS in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-13-2016, 09:29 AM
  3. [SOLVED] IF FALSE, skip to the next row
    By MYazal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2016, 06:28 PM
  4. [SOLVED] False value, then skip to next line, etc.
    By hidden78731 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-24-2016, 03:10 PM
  5. VBA ignore or skip worksheets if not available
    By sk88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 04:15 PM
  6. [SOLVED] How do I Skip a Row if the Value is False
    By coconnor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2012, 10:26 AM
  7. If false skip to next
    By irresistible007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2005, 07:10 AM

Tags for this Thread

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