nearest round figure

[nowfal]

HI guys,
I wanted a cell value to be rounded of nearest number in
formated cell. ie. 567 x 8.598 =4875.066 in this case i need th
answer as 4875.100 or vise verse 4875.050 . for this what type o
formula i have to give in that cell.
thanks in advance

 

[Jerry W. Lewis]

How you want to specify the rounding level is unclear from your post.
However the Analysis ToolPak function MROUND() may be what you want.

Jerry

 

[nowfal]

HI FRIENDS.
I AM GETTING A VALUE OF SOMETHING LIKE 47.35.
WANTED TO ROUNDING OF AS 47.50 FOR THAT WHAT KIND OF FORMULA I HAVE T
GIVE IN THAT CELL

 

[Dave Peterson]

Take a look at =MROUND() in excel's help. You'll see you can specify what to
round it to:

=MROUND(A3,0.5)

might be what you want.

 

[Peo Sjoblom]

If the OP doesn't have ATP installed he could use

=ROUND(A1/0.5,0)*0.5

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[nowfal]

I have already have a formula in the particular cell , where i am goin
to give MROUND formula.
that is like this
a b c d
1 2 3 =b*c

in D that formula' b*c' is there , the same cell 'd' i wanted to giv
the formula MROUND, how to add it?

thanks in advance

 

[AlfD]

Hi!

A formula is a very organic thing. You can develop it

Try =mround(a*b,0.5)

Or, if you are not on ATP, =ROUND(a*b/0.5,0)*0.5

Al

 

[nowfal]

THANK YOU VERY MUCH ALF
I AM JUST A BASIC STUDENT. SO PLEASE DONT FEEL BAD WHEN I AM ASKIN
SUCH SILLY QUESTIONS

 

[AlfD]

Hi!

You're welcome!

*I* don't feel bad: the important thing is that *you* must not fee
bad. I can't quite remember when I did my first spreadsheet, but
guess I've learned something from almost every one I've done since
and everyone I've encountered, especially on this board.

Al

 

[nowfal]

Mr. Alf had helped me for the same subject, but i need some mor
assistance, in which the rounding figure should not be go less, i
should go for the next higher amount only. Is there any possibility t
do so.
thx
nowfal

 

[AlfD]

Hi!

Try ROUNDUP.

=roundup(12.3,0) gives 13, for example.
The 0 causes it to round to the nearest integer above.

=roundup(12.62,1) would give 12.7.
The 1 causes it to round to 1 place of decimals. etc.

Al