Forum Discussion
Solved
Issue using the result from one formula for another formula
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
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.
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.
Thank youJoeUser2004 it worked. 🙂
