Excel Formulas - TechRepublic
Question
January 7, 2010 at 08:31 AM
dillon.damien

Excel Formulas

by dillon.damien . Updated 16 years, 6 months ago

I have a large excel spreadsheet which I want to apply the round formula to multiple cells.

For instance I have a table with linked figures divided by 1000.
i.e: in Sheet 1 cell B2 I have: “=(‘Sheet2’!B2)/1000)”

I want to have “=ROUND((‘Sheet2’!B2)/1000,0)”

Is there a way to apply this to multiple cells without manually typing the formula in to each of the hundreds of cells?

This discussion is locked

All Comments