Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to show 97.826 as 97.825
I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321
would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously not gr8 at excel so would appreciate som assistance Cheers Kevin |
#2
|
|||
|
|||
First, make sure the Analysis ToolPak is installed! Menu: ToolsAdd-Ins... tick the Analysis ToolPak if it is not already ticked. Then use this formula: =MROUND(A1,5) It will round to the nearest 5-multiple. HTH Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=389874 |
#3
|
|||
|
|||
One way:
=ROUND(A1/0.005,0)*0.005 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "KevinBoyden" wrote in message ... I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321 would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously not gr8 at excel so would appreciate som assistance Cheers Kevin |
#4
|
|||
|
|||
Not thru format. However using this function at each instance where you want
it rounded =Mround(a1,0.005) "KevinBoyden" wrote in message ... I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321 would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously not gr8 at excel so would appreciate som assistance Cheers Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Again-revealing the contents of formula | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
My formula will not show the result, only the formula. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) |