Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |