MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Aladin


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

OzGrid Business Applications

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")

OzGrid Business Applications

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
OzGrid Business Applications

Posted by Aladin Akyurek on February 08, 2001 4:26 AM

Of course. REST is MOD, however.

Aladin

Posted by Herman westerlaken on February 14, 2001 3:45 AM


GREAT i have got it working with the help of you guys i used the rest function

Thanx a lot