Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit numbers past decimal in formula result
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Formula to count numbers past a specified limit | Excel Worksheet Functions | |||
Formula without using numbers after decimal in the answer | Excel Discussion (Misc queries) | |||
How do I get rid of infinite numbers past the decimal place? | Excel Worksheet Functions | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) |