Software

Ask something
Question Locked

Excel Formulas

0 helpful
3 replies

by dillon.damien

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by dillon.damien

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:
='Sheet2'!J75
='Sheet2'!J76
='Sheet2'!J77
An the cell values in column C are:
='Sheet2'!K75
='Sheet2'!K76
='Sheet2'!K77

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:
='Sheet2'!J75
='Sheet2'!J76
='Sheet2'!J78
in column C:
='Sheet2'!L75
='Sheet2'!L76
='Sheet2'!L78

Any suggestions?

Thanks!

This discussion is closed to new replies.