| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a decimal number return to zero
I am looking to make a decimal number return to zero. Example
if AI EQUALS 37.5 I want to do a formula that divides AI by 2 and when it comes out to 18.75 which is not a whole number then it should state the cell as zero if it is a whole number then it would return the whole number to that cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a decimal number return to zero
On Wednesday, October 19, 2016 at 10:36:20 AM UTC-7, wrote:
I am looking to make a decimal number return to zero. Example if AI EQUALS 37.5 I want to do a formula that divides AI by 2 and when it comes out to 18.75 which is not a whole number then it should state the cell as zero if it is a whole number then it would return the whole number to that cell. Maybe something like this: =IF((A1/2) = INT(A1/2), A1/2, 0) |
|
#3
|
|||
|
|||
|
Quote:
or =(A1/2)*(1-SIGN(MOD(A1/2,1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make excel automatically add a decimal | Excel Worksheet Functions | |||
| how to make value whole (remove decimal point) | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| Make divisions and display no decimal value at the quotient! | Excel Discussion (Misc queries) | |||
| How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
Linear Mode
