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

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

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