How can I round a number to the nearest "50" or "100" in excel 200

what to do with 75?

"Manny" <Manny@discussions.microsoft.com> schreef in bericht
news:686D710C-E451-409F-A44D-3F6C25195977@microsoft.com...
>I have a odd number and would like to round it off the nearest 50 or 100
> whichever is closer. Can that be done? If yes how. Thanks

In article <686D710C-E451-409F-A44D-3F6C25195977@microsoft.com>,
Manny@discussions.microsoft.com says...
> I have a odd number and would like to round it off the nearest 50 or 100
> whichever is closer. Can that be done? If yes how. Thanks
>
Since 100 is a multiple of 50, just round to 50. It will yield the
necessary result. If the number of interest is in A1, use
=ROUND(A1/50,0)*50.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

I have a odd number and would like to round it off the nearest 50 or 100
whichever is closer. Can that be done? If yes how. Thanks

what to do with 75?

"Manny" <Manny@discussions.microsoft.com> schreef in bericht
news:686D710C-E451-409F-A44D-3F6C25195977@microsoft.com...
>I have a odd number and would like to round it off the nearest 50 or 100
> whichever is closer. Can that be done? If yes how. Thanks

In article <686D710C-E451-409F-A44D-3F6C25195977@microsoft.com>,
Manny@discussions.microsoft.com says...
> I have a odd number and would like to round it off the nearest 50 or 100
> whichever is closer. Can that be done? If yes how. Thanks
>
Since 100 is a multiple of 50, just round to 50. It will yield the
necessary result. If the number of interest is in A1, use
=ROUND(A1/50,0)*50.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions