Excel Formulars RRS feed

  • Question

  • 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,


    Wednesday, January 5, 2011 9:29 PM