SOLVED

# Issue using the result from one formula for another formula

Copper Contributor

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

Sandra

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

# Re: Issue using the result from one formula for another formula

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

# Re: Issue using the result from one formula for another formula

Thank you@JoeUser2004 it worked. 🙂

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

# Re: Issue using the result from one formula for another formula

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