HOW TO REPLACE multiple data in mutliple cells with new data calculated with same formula?

Question

This is driving me crazy, can't find an answer,

IN EXCEL 

If i have many cells with data, now i need to change these data by applying same formula to these cells, this is like replacing these data in multiple cells, how to do this quickly?

Answer 1

Okay, so i can use formula and put new data into other cells, but what i want is to replace the current data with new data calculated with the formula,  then i try copying the new data to the current cell, it can't, 

so how to do it?

Answer 2

Hi Trade1234

You cannot just replace a value in a cell with a formula, because that formula would be referring to the old value in that cell and a cell can only hold either a formula or data, but not both

You would need to store the data in other cells then put the formula in I12, referring to that data in another cell

Answer 3

Hi

thanks for your reply

Those cells currently don't have formular, only price, data,  I simply want to replace them all by applying same formula which is , for example,  the I12: (i12*0.02)/7.08 "

I want to replace the current data by using formula on the current data, the formula I want to use is " (i12*0.02)/7.08 ", but there are mutiple one i need to replace, how to do it once and quickly? 

below is screen shot,  the current data is in red circle 

Answer 4

Find and replace will work

Answer 5

HI Trade1234

Can you please provide more detail on your question and on your data . ..

Do those cells currently contain a formula or just data, and do you now want to change that to a different formula?

Please provide a screenshot of your worksheet, showing row numbers and columns, and provide a full explanation of the changes you want to make . . .