View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default EXCEL: MOD FUNCTION or DIVISION

Pl turn off the caps lock ..

Some options to try:
=ROUNDDOWN(A1/35,0)
=INT(A1/35)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NAIMA" wrote:
=ROUND(A1/35,0)
HOW DO I GET IT TO ROUND DOWN TO THE WHOLE NUMBER

1000/35 = 28.571
I WOULD LIKE IT TO READ 28 INSTEAD OF 29 IS THAT POSSIBLE?
THANK YOU FOR YOUR HELP :) :)