View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default 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)