Round Funtion

[otis1978]

cannot seem to figure why this formula will not work?
<table border="0" cellpadding="0" cellspacing="0" width="90"><tr height="24"><td class="xl66" style="height:18.0pt;width:68pt" height="24" width="90">
</td></tr></table>=round(b16-b12/b16,0)

thank you

 

[Peter_SSs]

cannot seem to figure why this formula will not work?
<table border="0" cellpadding="0" cellspacing="0" width="90"><tr height="24"><td class="xl66" style="height:18.0pt;width:68pt" height="24" width="90">
</td></tr></table>=round(b16-b12/b16,0)

thank you

In what way does it not work?

What do you have in B12 and B16?

What result do you expect and why?

 

[id107]

As Peter has said, it would be beneficial to know what's in the cells and the desired result, but I'm assuming (which rarely works well for me ) that you're missing parenthesis
=round((b16-b12)/b16,0)

 

[otis1978]

sorry, this is the formula I am trying to make work:

=round(b16-b12)/b16,0)

b12 is simply a number I input
b16 contains a formula: =B5*B8*B9*B10

thanks again...

 

[Peter_SSs]

sorry, this is the formula I am trying to make work:

=round(b16-b12)/b16,0)

b12 is simply a number I input
b16 contains a formula: =B5*B8*B9*B10

thanks again...

Well, that formula has two closing ")" and only one opening "(" so maybe you need the formula Craig posted. If that does not fix it please address the questions I asked before ..

In what way does it not work? (does it give the wrong answer, an error value, something else? Give detail)

What do you have in B12 and B16? (examples of the actual values. Give detail)

What result do you expect and why? (??? Give detail)

 

[otis1978]

the error says i have entered too few arguments for this function...
-- removed inline image ---

 

[paulpitchford]

=round((b16-b12)/b16,0)

As Peter said, you are probably missing a parenthesis off of the start of the function.

HTH! Paul.

 

[Hedz]

The syntax for round is round(numbertoround;decimals) so you are missing the number for decimals. =round(5,6789;2) gives 5,68 =round(5,6789;0) gives 6

 

[Peter_SSs]

The syntax for round is round(numbertoround;decimals) so you are missing the number for decimals. =round(5,6789;2) gives 5,68 =round(5,6789;0) gives 6

Depends on the language version of Excel. The separator between 'numbertoround' and 'decimals' may be a ';' as you have quoted but for the standard English version of Excel it is a ','
so I think the OP actually has the decimals covered by the ,0) at the end of the formula but has a missing parenthesis elsewhere as has been suggested a couple of times.

BTW, Welcome to the MrExcel board!

 

[otis1978]

got it fixed, was simply missing a (

many thanks for all the help...