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
