Check for Integer values in Cells

[anandrajagopal]

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

[JieJenn]

In I2, enter =IF(ROUND(ABS('TD '!I2-'DB2'!I2),-2)<=0.01,TRUE,FALSE) then fill the formula. The round function addresses the float decimal issue.

[YasserKhalil]

May be

Please Login or Register  to view this content.

[anandrajagopal]

Hi Team,

Thanks for the reply.

Can you please have the code in Vba for the above excel sample document?

Thanks
R Anand