Formula Help

[dem]

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.

[JMB]

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.

[ScottO]

Try this ...
=IF(ISEVEN(INT(B1)),INT(B1)+1,"Do something else")
Rgds,
ScottO

"dem" <[email protected]> wrote in message
news:[email protected]...
| 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.