I'm not sure that the isodd function exists, unless it is an UDF but if
I am understanding you correctly you want to find what Q6/C3 equals,
and if it is even then you want that number displayed and if it is odd
you want to move it up to the next even number (?)

If so then this should work:

=EVEN(Q6/$C$3)

I'm not sure that you need the SUM function in there and if you are
writing that equation in cell R6 then you will be creating a circular
reference when referring to EVEN(R6)

Does this help?


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=502477