Extra Pair of Brackets gives different result

[nosense]

I have a following formula:

=((R32/M32)^(P32-1))-((K32^(2*P32))*(R32/M32)^(-P32-1))The result of this is '0' .

Then when I use same formula but with extra brackets on the outside =(((R32/M32)^(P32-1))-((K32^(2*P32))*((R32/M32)^(-P32-1)))) it gives me something other than 0 .

Where I s a problem ?

Thanks

[dominicb]

Good morning nosense

It's not just an opening bracket at the start and a close at the end. Formula 1 starts and ends with two brackets. Formula 2 starts with three and ends with four brackets.

After the first multiply (*) sign, you have a single opening bracket in formula 1 and a double in formula 2.

HTH

DominicB

[nosense]

Thanks for pointing this out, I have fixed it but still does same thing

=(((R32/M32)^(P32-1))-((K32^(2*P32))*((R32/M32)^(-P32-1))))
and

=(((R32/M32)^(P32-1))-((K32^(2*P32))*((R32/M32)^(-P32-1))))

[JohnTopley]

The error is nothing to do with the brackets:

=(((R32/M32)^(P32-1))-((K32^(2*P32))*(R32/M32)^(-P32-1)))

works fine for me.

I copied/pasted your "error" formula and it worked OK also.


Post a file showing the error condition.

[Jonmo1]

Those 2 formulas (in Post #4) are identicle.
So I would certainly expect both to produce the same result.

[nosense]

I agree,
But they give me different result!
Please see in the sheet attached the yellow highlighted cells have same formulae in but different results.

[Jonmo1]

Why are you trying to add () around the original formula?

There is more that is different between the 2 formulas than just the outside (brackets)

Here is your original formula, with brackets around it
=(((R32/M32)^(P32-1))-((K32^(2*P32))*(R32/M32)^(-P32-1)))

[Jonmo1]

I see it now..

Pretty sure it's related to the Floating Point Precision issue (google it)
Basically not all decimal values can be stored precisely in a binary system
The result you see in T41 is a miniscule value less than absolute 0, shown in Scientific notation.
A further calculation of =T41+1 results in 1.

I think the extra () creates an additional calculation step, revealling the FPP issue.

[Jonmo1]

Format both cells as Number with about 16 decimals, you'll see the difference.