Thread: How to stop excel from rounding ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default How to stop excel from rounding ?
Hi majestikwun,

Rounding up is the mathematically correct way to do it.
You can use ROUNDOWN as a workaround.

i.e.
=ROUNDDOWN(A1,8) for your first example
=ROUNDDOWN(A1,2) for your second example

HTH
Martin


Reply With QuoteReply With Quote