View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
WannaBeExceller WannaBeExceller is offline
external usenet poster
 
Posts: 22
Default Is there a quotient function in VBA that's like Mod

Thank you for your response. I found that to work as well as just using the
"\" sign in the division instead of using "/". Thank you once again.

"Niek Otten" wrote:

=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.