View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Mod function not working right?

Hard to know if you're doing it wrong, since you don't say what you're
trying to do.

Mod is an operator, so it only makes sense in an assignment statement.
For instance:

a = 26 Mod 3

returns 2 to the variable a.

A bare

26 Mod 3

doesn't make sense - it's like putting the number 2 as a statement.

In article ,
DMB wrote:

this formula is giving me an error. I need the remainder. Am I doing this
wrong?

26 Mod 3