View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default omit numbers past decimal in formula result

=roundup(round(A1)/4,0) or rounddown instead of round...

"DebC" wrote:

In a prefilled form, the formula in cell B1 is: =roundup(A1/4,0)
Cell A1 = 24, so the answer should be 6.

My problem is that even tho the cell displays the number as 24, the actual
number takes it several places past the decimal, (24.0000000000002) as the
result of another formula, so the result in B1 is 7 instead of 6. Is there a
way to prevent this and work with the whole number only? I hope I have given
enough information, but if not I will be happy to provide more details as
needed. Thanks in advance for any help.