+ Reply to Thread
Results 1 to 2 of 2

Print results of IF statement

  1. #1
    Registered User
    Join Date
    08-07-2005
    Posts
    2

    Print results of IF statement

    I want to evaluate a given cell in a given row; if value exceeds 12, select the row for subsequent printing. If value <12, add first cell's value to previous cell (in same row) and re-evaluate ... if that value >12, then, select the row for printing. If either value above <12, DO NOT select for printing. Apply same logic to all rows and then have selected rows PRINT OUT. Is this possible? Thanks in advance.

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    What you ask can be done, but would require a macro to work.

    One question, you say:
    If value <12, add first cell's value to previous cell (in same row) and re-evaluate
    Using this logic, you are ONLY working in one row and that row will eventually be printed. Do you, instead mean "...previous cell (in same column)..."?

    I also suggest you post this in the Programming forum instead of this one.

    Cheers,

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

+ Reply to Thread

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