Rounding in Excel

[trichey]

I am trying to round a cell either up to the nearest 500 or down to the
nearest 500...any suggestions. My current formula is =ROUNDUP(A2*1.3,500).
Help?

 

[Mike H]

Try

=MAX(A1,mround(A1,500))

The max bit would make 0 - 249 sray as that number but if you want these to
be zero then use

=mround(A1,500)

If you get a #name error then
Tools|Addins
Check the analysis toolpack

Mike

 

[Stefi]

Try this:
=FLOOR(A2,500)
=CEILING(A2,500)

Regards,
Stefi

„trichey†ezt írta: