Issue using the result from one formula for another formula

[SandraG2022]

Hello and help,

I have not come across this type of problem until today.

It would be great if someone has a simple answer for me. :)

D1=25;  D5=0.79; D10=387; J1=453.6

Here is my problem: I have a simple formula in D11 =(D1*D5)/J1 I am getting the correct result and used the formatting "number decimal places 3" so the result shows as 0.044

When I am using the result from D11 for another formula at D12 =D10*D11 it gives me a wrong result (16.85) If I would type 0.044 instead of addressing it to the cell D11 it shows the correct result 17.028

What can I do to get the correct result? I even tried to copy the result in a different cell but with the same outcome.

Please help. :)

Sandra

[#2 · Accepted solution]

@SandraG2022  wrote:  ``I have a simple formula in D11 =(D1*D5)/J1 I am getting the correct result and used the formatting "number decimal places 3" so the result shows as 0.044[.] When I am using the result from D11 for another formula at D12 =D10*D11 it gives me a wrong result (16.85)``

Explicitly round to the precision that you want.  For example:

=ROUND(D1*D5/J1, 3)

or

ROUND(D11, 3)  where you reference D11

Usually, formatting affects only the appearance of the value, not the actual cell value.

[#3]

Thank you@Joe User it worked. :)