Re: Rounding to
- From: "Steven" <none@xxxxxxxxx>
- Date: Fri, 24 Nov 2006 18:43:23 -0500
Ok, this is a little more complicated than just rounding. Column B has a
figure which is multiplied by column D to get the amount in column F. So
right now, it looks like =B3*D3 and what I need it to do is round that
figure to the nearest 50. So it would be something like
=(B3*D3)=Round(F3,50))? Sorry I did not get this on sooner.
"Steven" <none@xxxxxxxxx> wrote in message
news:%232XwkuAEHHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
I have a column of numbers, all multiples of 10, starting at 100 and going
up into the thousands. I want to round them to the nearest 50, so 140 would
become 150 and so would 160. How do I do that?
TIA
Steven
I plan to live forever.....or die trying!
.
- Follow-Ups:
- Re: Rounding to
- From: Bob Phillips
- Re: Rounding to
- References:
- Rounding to
- From: Steven
- Rounding to
- Prev by Date: Re: Dates to week numbers help.
- Next by Date: Insert rows and paste without clearing constants
- Previous by thread: Re: Rounding to
- Next by thread: Re: Rounding to
- Index(es):
Relevant Pages
|
