| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel formula to end number in .005 or .000
I have an excel spreadsheet that shows trade calculations, the numbers are to
3 decimal places, but the last digit should only read as 5 or 0 how can I get this to work and strip out the 12346789 numbers? Thanks in advance Kevin |
|
#2
|
|||
|
|||
|
One way:
=ROUND(A2*2,2)/2 In article , "KevinBoyden" wrote: I have an excel spreadsheet that shows trade calculations, the numbers are to 3 decimal places, but the last digit should only read as 5 or 0 how can I get this to work and strip out the 12346789 numbers? Thanks in advance Kevin |
|
#3
|
|||
|
|||
|
Thank you V much, perfect....
Kevin "JE McGimpsey" wrote: One way: =ROUND(A2*2,2)/2 In article , "KevinBoyden" wrote: I have an excel spreadsheet that shows trade calculations, the numbers are to 3 decimal places, but the last digit should only read as 5 or 0 how can I get this to work and strip out the 12346789 numbers? Thanks in advance Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
| Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) | |||
| Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
