Forum Discussion

SandraG2022's avatar
SandraG2022
Copper Contributor
Oct 07, 2022
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 ha...
excel
Formulas and Functions
  • JoeUser2004's avatar
    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's avatar
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)

or

ROUND(D11, 3)  where you reference D11

 

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

Resources