Thread: Formula Help
View Single Post
  #2   Report Post  
JMB
 
Posts: n/a
Default Formula Help

Maybe

=IF(ISEVEN(INT(A1)),CEILING(A1,INT(A1)+1),A1)

"dem" wrote:

If cell B1 value is any even number with or without decimal (ie could be 26
or could be 26.23) value must be rounded to next whole integer odd value (ie
27). Thanks for helping.