View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default I WANT EVEN NUMBERS; NO DECIMALS - ROUND

=floor(A1,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"HERNAN" wrote in message
...
I just need to do this really simple task but Im getting crazy... I just

want
even numbers from a calculation cell.
If the result is: 2.1 I want it show 2 if its 2.9 also 2
if
0.9 = 0
1.0 = 1
etc etc

If you can help me; thank you sooo much!!