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 ha...

excel

Formulas and Functions

JoeUser2004
Oct 08, 2022
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.

JoeUser2004

Bronze Contributor

Oct 08, 2022

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)

ROUND(D11, 3) where you reference D11

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