Excel Formulas

By Dillon.damien ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Copy and paste

by neilb@uk In reply to Excel Formulas

works fine for formulae. It will update the cell reference

Neil :)

Collapse -

Sort of works

by Dillon.damien In reply to Copy and paste

I am able to copy and paste the formula only if the cells in the linked sheet are adjacent.

For instance:
If the cell values in column B are:
An the cell values in column C are:

Copy&Paste works.

However if the values are as below, copy and paste results in the same outcome as with the numbers above:
in column B:
in column C:

Any suggestions?


Related Discussions

Related Forums