[Solved] Excel macro to find cells with numbers larger than 20 in a specific column and then divide the matching cells by 1000 [closed]

Question

Let’s say your Kb values start in row 1 of column A, write this formula in column B :

=IF(A1>20, A1/1000, A1)

Basically, what this does, is tell the computer that if A1 is greater than 20, put A1/1000 in this cell, otherwise put A1. Stretching this formula down the column will give you the right formula for each row.

Accepted Answer

Let’s say your Kb values start in row 1 of column A, write this formula in column B :

=IF(A1>20, A1/1000, A1)

Basically, what this does, is tell the computer that if A1 is greater than 20, put A1/1000 in this cell, otherwise put A1. Stretching this formula down the column will give you the right formula for each row.