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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit numbers past decimal in formula result
d'oh
=roundup(round(A1,0)/4,0) "Sean Timmons" wrote: =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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit numbers past decimal in formula result
Cell A1 = 24...as the result of another formula
Is there a way to prevent this and work with the whole number only? You could use the ROUND function in the formula in cell A1: =ROUND(your_formula,0) Or, you could round down to the whole number in your current formula: =ROUNDUP(INT(A1)/4,0) -- Biff Microsoft Excel MVP "DebC" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit numbers past decimal in formula result
Thank you so much! As far as the formula on the destination page, I have no
input. I'm stuck with the formulas that are prefilled. However, I was able to use this on my original worksheet that transfers to it. Huge help! "Sean Timmons" wrote: d'oh =roundup(round(A1,0)/4,0) "Sean Timmons" wrote: =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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit numbers past decimal in formula result
Thank you very much. I get such good help from this site!
"T. Valko" wrote: Cell A1 = 24...as the result of another formula Is there a way to prevent this and work with the whole number only? You could use the ROUND function in the formula in cell A1: =ROUND(your_formula,0) Or, you could round down to the whole number in your current formula: =ROUNDUP(INT(A1)/4,0) -- Biff Microsoft Excel MVP "DebC" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit numbers past decimal in formula result
You're welcome!
-- Biff Microsoft Excel MVP "DebC" wrote in message ... Thank you very much. I get such good help from this site! "T. Valko" wrote: Cell A1 = 24...as the result of another formula Is there a way to prevent this and work with the whole number only? You could use the ROUND function in the formula in cell A1: =ROUND(your_formula,0) Or, you could round down to the whole number in your current formula: =ROUNDUP(INT(A1)/4,0) -- Biff Microsoft Excel MVP "DebC" wrote in message ... 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. |
Reply |
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) |