+ Reply to Thread
Results 1 to 10 of 10

How to skip cells instead of getting false using IF function.

  1. #1
    Registered User
    Join Date
    01-12-2023
    Location
    Riyad Saudi Arabia
    MS-Off Ver
    7.3.7
    Posts
    5

    Exclamation How to skip cells instead of getting false using IF function.

    Hi,
    I have a table on which I want to apply a formula that changes values but I want some of them to change while those unaffected by the formula remains the same as I don't want "FALSE" or empty space to replace the previous data of the cell.
    More precisely looking at the table below we have

    Column A Column B

    Bugatti Vehicle
    Bugatti Vehicle
    Bugatti Vehicle
    Kawasaki Bike
    Kawasaki Bike
    Bugatti Vehicle

    Now I want all the "Vehicle" to change to "car" in column B for every "Bugatti" in column A. But I don't want the "Bike" to be changed to "False" or empty space.
    (Consider the table very big where you can't just separately select all cells including "Bike" as it would consume hours/days)

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: How to skip cells instead of getting false using IF function.

    The fastest way is to record the code yourself and complete it with one button

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-12-2023
    Location
    Riyad Saudi Arabia
    MS-Off Ver
    7.3.7
    Posts
    5

    Re: How to skip cells instead of getting false using IF function.

    I did apply the code you gave and it worked like a charm but I forgot to mention that there are many random values that are not the same.
    For Example not all the values in column B are "Bike" there is like ("Bicycle", "Boat", "Not-Vehicle" etc) many different values.

    In the code, you gave me it does leaves "Bike" as it is but I have others that I want to be as they're. Now I can copy the first three lines of code and replace "Bike" with the other values I have. In doing so I will have to go through 27k entries to check for different values. So, far I have about 100+ different values.

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: How to skip cells instead of getting false using IF function.

    Because the data you provided before is limited, it can only be processed according to the samples provided. There are methods. Please provide more samples to see what kind of combination your data structure is.

  5. #5
    Registered User
    Join Date
    01-12-2023
    Location
    Riyad Saudi Arabia
    MS-Off Ver
    7.3.7
    Posts
    5

    Re: How to skip cells instead of getting false using IF function.

    I am gonna make a table very similar to the one I have so that the question is clearer.

    1 Column A Column B
    2
    3 Bugatti 5
    4 Bugatti 5
    4 Tea 15
    5 Bugatti 8
    5 Kawasaki 9
    6 Coffee 8
    7 Tea 15
    8 Bugatti 5

    In the above table, I want to replace all the numeric values of "Bugatti" in column B with "1" without altering all the other values. When I apply a simple formula (=IF(A3:A8="Bugatti", "1") on column B it does work but it appears to replace other values in column B with "False" since the formula doesn't apply to it. But I don't want that to happen I want its value to remain as it is, in other words, I want the formula to skip that cell somehow and leave its numeric value as it is.

    I hope it's clearer and more understandable now.

    (I have a total of 27k entries and I want a formula to carry this task as I can't do it manually)

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: How to skip cells instead of getting false using IF function.

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    01-12-2023
    Location
    Riyad Saudi Arabia
    MS-Off Ver
    7.3.7
    Posts
    5

    Re: How to skip cells instead of getting false using IF function.

    It does print "1" for "Bugatti" but it changes the values in other cells to "#value" because they simply don't meet the criteria and I don't want that to happen I want it's value to be untouched by the formula

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: How to skip cells instead of getting false using IF function.

    In that case can you please upload a workbook showing the problem.
    Also what version of Excel are you using? 7.3.7 is not a valid version of Excel.

  9. #9
    Registered User
    Join Date
    01-12-2023
    Location
    Riyad Saudi Arabia
    MS-Off Ver
    7.3.7
    Posts
    5

    Re: How to skip cells instead of getting false using IF function.

    7.3.7 is the version of LibreOffice that I am using and I solved the problem by separating data into different columns and applied the formula you gave earlier one by one.

    Thanks all for your support and help.

  10. #10
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: How to skip cells instead of getting false using IF function.

    7.3.7 is the version of LibreOffice
    In that case you should have made that clear at the start. Whilst they may be similar they are not the same

    Glad you sorted it & thanks for the feedback.

+ 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 function (IF False skip to next row)
    By FatmaMS in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-13-2016, 09:29 AM
  2. [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
  3. Replies: 4
    Last Post: 03-08-2014, 02:03 PM
  4. [SOLVED] Skip false rows in If function
    By stevot38 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2013, 04:58 PM
  5. Skip False Statement in If And Function
    By peterpan1279 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 09:31 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. [SOLVED] 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