Results 1 to 4 of 4

Check for Integer values in Cells

Threaded View

anandrajagopal Check for Integer values in... 01-16-2015, 03:23 PM
JieJenn Re: Check for Integer values... 01-16-2015, 03:52 PM
YasserKhalil Re: Check for Integer values... 01-16-2015, 04:39 PM
anandrajagopal Re: Check for Integer values... 01-17-2015, 10:50 AM
  1. #1
    Registered User
    Join Date
    12-21-2014
    Location
    chennai
    MS-Off Ver
    2010
    Posts
    37

    Check for Integer values in Cells

    Hi Team,

    we have a scenario in which we need to check cells that has integer values.

    PFA of my sample excel document. here we have compared, TD and DB2 sheet. In Compared sheet, we have compared results of both TD and DB2. I need to consider the FALSE value in compared sheet cell of ONLY integer value in cell and compare the values of both DB2 and TD sheet.

    1. In our sample document we have FALSE values in DISCOUNT column by comparing values of DB2 and TD sheet. Actually the values in DB2 sheet is 10.2 and in TD is 10.19 and so we are getting FALSE in compared sheet. But we need to make it as TRUE if the difference value is 0.01 i.e 10.2 - 10.19 = 0.01

    2. In Compared Sheet we may have may FALSE value. We need to take only the FALSE value of Integers in both DB2 and TD sheet.

    Please advice us how to achieve this

    Thanks
    Anand R
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. possible to check for file in multiple folders, then check for values in specific cells?
    By mattheritage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 08:33 AM
  2. [VBA] Check if an integer is contained in a range of cells in a worksheet
    By thedunnyman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 11:25 PM
  3. Solver - Changing cells to text values not integer
    By Kinnan in forum Excel General
    Replies: 0
    Last Post: 08-15-2010, 08:46 AM
  4. [SOLVED] Check if a value is an integer using VBA code
    By Rayo K in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2006, 04:45 PM
  5. [SOLVED] how do I test for Integer?:check out ROUND
    By DerbyJim1978 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM

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