View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default

Hi!

But, by adding the brackets, I give the computer definite instructions
which
eliminates a possible problem. (I hope this is so.)
Do you agree with my thinking?


Yes! But in the case of your example it's not necessary since it is only a
single math operation to divide D6 by D7.

In your first example the order of precedence is not exactly as you think
(but you're close!)

=b2/(c4+c5)

Assume:

B2 = 10
C4 = 5
C5 = 5

B2/ gets evaluated first, not (C4+C5)

So:

10/(C4+C5)

10/10 = 1

Biff

"Ed" wrote in message
...
Cell formula
=b2/(c4+c5)
I know that in this case, c4+c5 will get performed first because it is in
brackets.

Now, here is my question.
=ROUNDUP((D6/D7),0)

In this formula, do the brackets around the division cause the division to
be performed first even though they are within the roundup brackets?
Or would it do the division first anyway, without the brackets?

I am thinking that the default procedure would do the division first
without
the brackets.
But, by adding the brackets, I give the computer definite instructions
which
eliminates a possible problem. (I hope this is so.)
Do you agree with my thinking?
Ed