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


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.

1

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