ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula Help (https://www.excelbanter.com/new-users-excel/51514-formula-help.html)

dem

Formula Help

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

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.

ScottO

Formula Help

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

"dem" wrote in message
...
| 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.

All times are GMT +1. The time now is 02:29 AM.