How to round off values

[Ajay Gupta]

How can i round off 8790 to multiple 0f 500

i.e it gets round off to 9000 or 8500.

i have tried round off formula it is not working please help

Thanks

 

[SirJB7]

Hi, Ajay Gupta!

Tried this?

=REDOND.MULT(8790;500) -----> in english: =MROUND(8790,500)

Regards!

 

[Debraj]

Hi Ajyay,


To get round UP use

=CEILING(A1,500)

and to get round Down use

=FLOOR(A1,500)

In multiply of 500..


@ Pablo.. Its nice to watch both you fighting..


Regards,

Deb

 

[Ajay Gupta]

Ya this formula helps. I Wasnt aware of it

Thanks a lot for such a spontaneous reply

It was very urgent

Thanks

 

[NARAYANK991]

Hi Ajay , Debraj ,


I think you will find this useful :


http://spreadsheets.about.com/od/excelroundingfunctions/tp/090823-rounding-numbers-excel-2007-hub.htm


Narayan

 

[SirJB7]

Hi, Ajay Gupta!

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!


@Debraj Roy

Hi, Deb!

I don't know what do you mean by fighting...

If you're referring to NARAYANK991 and me, furthermore that it's on other topic, I think we're just interchanging ideas.

Regards!

 

[Debraj]

@ SirJb7 & Narayank991


Its an Eye-Pleasure.. not something like WWF..

 

[NARAYANK991]

Hi Debraj ,


You are right , I think it's not war , but it is WWF ! Everyone knows WWF is pure entertainment.


Narayan

 

[SirJB7]

Hi, Ajay Gupta!

I guess you don't mind, as you have the formula yet...

Regards!


@Debraj Roy

Hi!

I was just wondering... you know, my Spanish, your English, your other strange and exotic languages... WWF... oh, I got it!

http://www.wwf.org/

I'm the diver -1st photo-, in fact I'm a 2-star CMAS 20 year diver (last 5 with no exercise)... so I guess who should be him?... 2nd or 5th ones?

Regards!