vba code help needed for decimal values

[vranjit138]

Hi Geeks,
I have a peculiar scenario .. i have list of values in column a and b from for rows 1 to 20 . Range from A1 to B20 shows values as 0.00 in the cells but these are actually decimal values like in cell A1 = 0.000003456 and B1 = 0.000002345. I want to write a vba code so that i can put in column C as true or false based on the values in col A and B. I need the vba code so that i can use it as a part of a logic in a module.
Please help with the vba code. I tried to declare variables as double and ran a for loop but did not get the intended result.

 

[aRandomHelper]

You need to be more specific.

cell A1 = 0.000003456 and B1 = 0.000002345 , in this case do you want C1 to show as True or False? True meaning they are considered the same when rounded to 2 decimals. False meaning the full value must be used for comparison (this is the default behavior).

 

[vranjit138]

i need to see False in Cell C1

 

[aRandomHelper]

Then probably something like this:

    Dim i As Long
    For i = 1 To 20
        ActiveSheet.Cells(i, "c").Value = ActiveSheet.Cells(i, "a").Value = ActiveSheet.Cells(i, "b").Value
    Next