View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Displayed results in a cell

Do you mean the nearest multiple of 10? If so then

=MROUND(24.5,10) returns 20

=MROUND(25.5,10) retuns 30

--
Regards,

OssieMac


"WavMaster" wrote:

Can the product of a formula be rounded to the nearest number divided by 10?
If so how?