Could someone give me a hand working with the IFODD function. I can get it to work by itself, but not within IF statement when AND is also included.
A1 can be set to "x" or" y".
A2 can be an EVEN or ODD number.
A3 should return "xxx" if A1 is "x", but should apply the ISODD function in reference to A2 if A1 is "y".
So, I'd like something similar to this (which does not work) to be applied to A3:
=IF(A1="x", "xxx",IF(AND(A1="y",ISODD(A2)),ISODD(A2),(anyforum lahere),0))
I know the above forumla is not correct, but have played with variations of ISODD(A2) and am unable to make it work within an IFstatement which also includes the AND function.
Can the ISODD function work within an IF statement with the AND function?