Data Validate to Even Numbers

**HardyRexion** · 02-24-2011, 07:39 AM

Hello

I'm sure this is an easy one for most of you but can I use Data Validation to only allow even numbers in my cells

Thank you

**DonkeyOte** · 02-24-2011, 07:40 AM

You can apply a Custom Rule of:

=IF(ISNUMBER(A1),MOD(A1,2)=0)

where A1 is the "active" cell when the validation is first set

edit: in reality the ISNUMBER test isn't required... =MOD(A1,2)=0 would suffice.

**johnjohns** · 02-24-2011, 07:43 AM

This can be one way

**HardyRexion** · 02-24-2011, 08:09 AM

Thank you. Job done. Wasn't aware of the Mod function

Re: Data Validate to Even Numbers