View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default ROUNDDOWN Excell function

I get 2. Excel 2000, XP Pro

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M8" wrote in message
...
I can't get ROUNDDOWN to work with embedded operations.
For instance:
=ROUNDDOWN(7-1,0) returns 6
BUT
=ROUNDDOWN(((7-1)/3),0) will return 1 instead of 2

what is going on?