possible to check a cell for both even number and positivenumber.....

  • Thread starter Thread starter M G Henry
  • Start date Start date
M

M G Henry

I have found a workable formula to check for even numbers but I am not
being sucessful in having it also check for positive numbers.....

I am using the following data verification statment to check for even
numbers and it works fine.....

=MOD(G17,2)=0

problem is that the number they are supposed to enter has to be a
positive number because negative numbers are invalid data in this
application.

Any help would be appreciated.
 
Hi
Try this one. =IF(AND(MOD(G17,2)=0,G17>0),"True","")
HTH
John






- Show quoted text -
Click to expand...

Perfect, that was exactly what I was looking for.....

Thanks John......
 
You're welcome, glad to help.
John
Hi
Try this one. =IF(AND(MOD(G17,2)=0,G17>0),"True","")
HTH
John
message





- Show quoted text -
Click to expand...

Perfect, that was exactly what I was looking for.....

Thanks John......
 
Back
Top