View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] feerggy@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.