rounding off with links

[mavy]

How do I round off the result of a formula or links of adding the amounts in
different worksheets?

I tried =ROUND((!H15!K15+!L15,0) and
=MROUND((!H15!K15+!L15,0) but it doesn't round off. Is there a possible way
or I just have to manually enter the numbers? I want to round it off to the
nearest 100 or 1000 as well.

Thanks!

 

[Peo Sjoblom]

You have some strange formula in the ROUND function

what is this

!H15!K15+!L15

supposed to mean?


Anyway, to round to the nearest 100 use

=ROUND(A1,-2)

1000

=ROUND(A1,-3)

replace A1 with whatever you want to round

--


Regards,


Peo Sjoblom

"(e-mail address removed)"

 

[David Biddulph]

I can't see quite what you are trying to do.
I don't understand the syntax where you have 2 opening parentheses and only
1 closing parenthesis.
Similarly I don't understand quite what all your ! symbols are doing; some
might be delimiting sheet names, but they can't all be doing that. What
does your formula look like before you try to do the rounding?
If your original formula is ='H15'!K15+L15 (adding cell L15 on the current
sheet to cell K15 on a sheet names H15), then =ROUND('H15'!K15+L15,0) would
round to zero decimal places, and =MROUND('H15'!K15+L15,5) would round to a
multiple of 5, for example. =ROUND('H15'!K15+L15,-2) would round to -2
decimal places, in other words to the nearest 100.
=MROUND(...,0) doesn't make sense, as that would be asking the answer to be
a multiple of zero.

 

[mavy]

Well the synatx is because I was planing to rename the sheet but forgot to do
so. BUt you got what I meant I think. It worked! Thanks for the help!
--
thank you!
Mavy

I can't see quite what you are trying to do.
I don't understand the syntax where you have 2 opening parentheses and only
1 closing parenthesis.
Similarly I don't understand quite what all your ! symbols are doing; some
might be delimiting sheet names, but they can't all be doing that. What
does your formula look like before you try to do the rounding?
If your original formula is ='H15'!K15+L15 (adding cell L15 on the current
sheet to cell K15 on a sheet names H15), then =ROUND('H15'!K15+L15,0) would
round to zero decimal places, and =MROUND('H15'!K15+L15,5) would round to a
multiple of 5, for example. =ROUND('H15'!K15+L15,-2) would round to -2
decimal places, in other words to the nearest 100.
=MROUND(...,0) doesn't make sense, as that would be asking the answer to be
a multiple of zero.