# Formule excel cel

Posted by Herman Westerlaken on February 07, 2001 11:48 PM

I want to check if a value in cel a4 is an odd number or not an odd number
and if it's odd then do formule x and if it's not odd then do formula y

can you help me

Posted by Aladin Akyurek on February 08, 2001 12:23 AM

=IF(ODD(a4),x,y)

where x and y are computations that you want to do.

Posted by Dave Hawley on February 08, 2001 12:50 AM

Hi Herman

I sure can..

Try this:

=IF(NOT(ISNUMBER(A4)),"",IF(ODD(A4),"Im Odd","Im Even"))

Hope this helps

Dave

Posted by Herman Westerlaken on February 08, 2001 12:54 AM

great but i am working on a dutch version and when i use the dutch equivalent even oneven then whatever stands in the cell the formule is always true ??

Posted by Dave Hawley on February 08, 2001 1:30 AM

Try this
=IF(MOD(A4,2)=0,"Even","Odd")

Posted by Aladin on February 08, 2001 2:16 AM

Posted by Aladin Akyurek on February 08, 2001 2:21 AM

Herman: gee, I'm really embarrassed.

The formula must be:

=if(mode(a4,2)=0,x,y)

In Dutch: =als(rest(a4)=0;x;y)

Dave: you seem to understand Dutch. :-)

Posted by Dave Hawley on February 08, 2001 3:01 AM

Aladin, I'm struggling to understand English, let alone Dutch :-)

I think MOD is what you mean not MODE!

Dave