View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Round Function Philosophy

Totally incorrect. Whether to use it or not depends on your requirements;
for example, if you are looking for an integral answer.
__________________________________________________ ______________________

wrote in message
ps.com...
I teach Excel classes at a community college, and have a very good
understanding of the Round fuction, except for one statement I heard
another instructor make one time which has left me curious. I heard
him say that you should always use the Round fuction in any formula
where any multiplication or division is taking place. I think that's
quite a broad statement, and if true, the spreadsheet world would be
covered with Round functions. But it does beg the question...is there
something to what he said? Is there a broad rule about when a Round
function needs to be employed, and perhaps when it should NOT be
employed?

Curious as to what you folks have to say. Thanks for your help in
advance.