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

    Shav

    Wednesday, January 5, 2011 9:29 PM

Answers