what to do with 75?
"Manny" <[email protected]> schreef in bericht
news:[email protected]...
>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" <[email protected]> schreef in bericht
news:[email protected]...
>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 <[email protected]>,
[email protected] 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
what to do with 75?
"Manny" <[email protected]> schreef in bericht
news:[email protected]...
>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 <[email protected]>,
[email protected] 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" <[email protected]> schreef in bericht
news:[email protected]...
>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 <[email protected]>,
[email protected] 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks