Question
-
Topic
-
Excel Formulas
LockedI 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?
All Answers
Viewing 1 reply thread