Thread
:
ISODD and EVEN formula
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
BSantos
Posts: n/a
ISODD and EVEN formula
=IF(isodd(SUM(Q6/$C$3)),EVEN(R6))
I have this formula in cell R6. I want it to basically sum q6/c3 and if the
answer is an ODD number change it to an EVEN number. In that same cell "R6"
Any help! :0)
Bonnie
Reply With Quote