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.

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.

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.

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.

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.

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.

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.