+ Reply to Thread
Results 1 to 5 of 5

Statement to return formula to the next row down, if formula's result if false?

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    14

    Statement to return formula to the next row down, if formula's result if false?

    Brief background:
    I'm creating a "calculator" to reduce the time it takes to format a file for my job. The file has to be formatted very specifically as it is fed into our system. The idea is that I paste raw data into "sheet2" of the workbook and the file creates itself perfectly. All i have to do is save the file in the correct format.

    The first column of my file uses the following formula to add record indicator to each row that is populated with a value in the B column, else the cell is left blank:
    Please Login or Register  to view this content.
    Column two cells are populated using this formula, which looks at sheet2 (in which I copy/paste the raw data for the file) and if a value exists in the target cell, the value is added to the calculator sheet:
    Please Login or Register  to view this content.
    Subsequent columns use similar formulas, each based of whether or not the relevant cell in column B contains a value.

    MY QUESTION:

    Because the file format used is tab delimited, if I just extend the formulas used down the columns for a few thousand rows to guarantee all the records are created, the tab delimited file saves a whole bunch of blank rows which will cause errors in the system.

    Therefore, is there a way that I can make my formulas automatically add themselves to the next row, IF the current row is populated with values?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,745

    Re: Statement to return formula to the next row down, if formula's result if false?

    Not with tregular formulas, but it could be done with VBA.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-29-2014
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    14

    Re: Statement to return formula to the next row down, if formula's result if false?

    Thanks. I dont think ill be going into macros/vba for this, but out of interest could you point me towards some resources I could read that would help with what im after. Thanks in advance.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,745

    Re: Statement to return formula to the next row down, if formula's result if false?

    Im sure some of the members here could put something together for you. If you want, I can move this to teh VBA section?

  5. #5
    Registered User
    Join Date
    09-29-2014
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    14

    Re: Statement to return formula to the next row down, if formula's result if false?

    Yes Thank-you, appreciate the help.

+ 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. [SOLVED] Formula Shows result as FALSE
    By caabdul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2014, 04:48 PM
  2. [SOLVED] Why is this formula returning a FALSE result? It should return the value in B13
    By golfpromal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-20-2012, 05:22 PM
  3. Excel 2007 : IF statement with no result when FALSE
    By zitu708 in forum Excel General
    Replies: 2
    Last Post: 04-30-2010, 04:05 AM
  4. FALSE result from Averageif formula
    By ren1104 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-17-2007, 08:28 PM
  5. If formula result is false, how do I auto-delete that rows?
    By jbrenner51 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2005, 01:52 PM

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