IsEven ( Number )

Is the number Even?

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

IsEven( 0 )
IsEven( 2 )
IsEven( 3 )
IsEven("abc" )

Sample output:

0
1
0
0

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

//Author:   Kyle Williams
//Date:     12/20/2019
//Updated:  10/24/2022 - Updated the formula for isNumeric
//Purpose:  To determine if the number (or text) entered is a valid Even number:

If( 

//check if isNumeric:
Let(
	digits = Filter ( Number ; "0123456789.-" )
; 
       Length(digits) = Length ( Number ) 
   and Length(digits) <>0 
   and PatternCount( Number; "." ) < 2
   and PatternCount( Number; "-" ) < 2
   and If( PatternCount( text; "-" ) =1, Left(text;1)="-"; 1 )
)

and Number > 0; not Mod ( Number ; 2 ); 0 )

To determine if the number (or text) entered is a valid Even number:

Comments

		Fabrice Nordmann, 1-more-thing Dec 20, 2019
This is an odd function.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

IsEven ( Number )

Comments

Support this website.

Support this website.