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

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?