View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Is there a quotient function in VBA that's like Mod

=FLOOR(A1/B1,SIGN(A1)*1)

Or, if you only have positive numbers,

=INT(A1/B1)


--
Kind regards,

Niek Otten

"WannaBeExceller" wrote in
message ...
I am trying to do a division but only want the quotient part. I thought
there
would be a DIV function that works like MOD function. Thanks in advance.