Excel Formula
I have a column of data in excel, lets say , Column A
Column A has 1000 cells containing integer and float values.
I want to write a formula where:
1. Subtract each of the values in Column A by 100
2. Print those values in the same column, in other words, updating the Column A with the new values.
How can I do that using a formula?
Kind Regards,
Shav