SOLVED

Issue using the result from one formula for another formula

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)
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.