View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BSantos
 
Posts: n/a
Default 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