command for determing the remainder?

[bk]

I need to be able to determine if a Year is an even number away from this year (2004,6,8,etc.) I figured I could subtract 2002 from the Year I get from the user and then divide, a zero remainder means I have an even year.

I don't know the syntax for getting the remainder and I assume that there is one to use in XL and/or VB.

Thanks.

 

[AJ]

In a spreadsheet, try the
=MOD(number,divisor) function

 

[Calypso]

Have a look at "mod" in the VBA help. Would this do what you want?

 

[Aladin Akyurek]

On 2002-08-23 10:43, bk wrote:
I need to be able to determine if a Year is an even number away from this year (2004,6,8,etc.) I figured I could subtract 2002 from the Year I get from the user and then divide, a zero remainder means I have an even year.

I don't know the syntax for getting the remainder and I assume that there is one to use in XL and/or VB.

Thanks.

In the world of formulas it would be e.g.

=MOD(ABS(YEAR(A1)-B1),2)=0

where A1 houses a full-fledged date and B1 a value like 2004. With or without ABS...

Have also a look at the ISEVEN function...
This message was edited by Aladin Akyurek on 2002-08-23 11:03

 

[Mark W.]

Also...

=ISEVEN(2002-2004)

...which is supplied by the Analysis ToolPak add-in.

 

[Mark W.]

On 2002-08-23 10:59, Aladin Akyurek wrote:

On 2002-08-23 10:43, bk wrote:
I need to be able to determine if a Year is an even number away from this year (2004,6,8,etc.) I figured I could subtract 2002 from the Year I get from the user and then divide, a zero remainder means I have an even year.

I don't know the syntax for getting the remainder and I assume that there is one to use in XL and/or VB.

Thanks.

In the world of formulas it would be e.g.

=MOD(ABS(YEAR(A1)-B1),2)=0

where A1 houses a full-fledged date and B1 a value like 2004.

ABS() is unncessary. Negative numbers are even too!

 

[lenze]

I like ISODD better. How about

=ISODD(A1)=ISODD(B1)