Using a formula result in another formula

[kph]

In cell K3 I have a formula,=SUM(0.04*C3)-C3, which produces a numeric result. I am out what 4% of 9.04 is and then subtracting that amount.

I want to take the result of the formula in K3 and use it in another formula ,=SUM(K3-C3)*100, which is in the adjacent cell M3. Here I am subtracting the net amount (8.68), which is formual result found in K3.


My problem is that the result is not the correct answer. The answer should be 36.00 whereas it turns out to be 1,771.84

Got any ideas as to what I am doing wrong or how I can fix it. Thanks in advance.

 

[mvptomlinson]

Your first formula, in K3, should be:

=C3*0.04-C3
Your formula in M3 should probably be this if you expect 36.16:

=(C3+K3)*100
Subtracting the original number from 4% of the original number will always result in a negative number. Combine that with the original to get the difference.

Of course, you don't need K3 to get the result in M3. Just use

=C3*4

Although, not sure why 36 would be the difference of 9.04 and 8.6784. It would be .3616. (C3*0.04)

 

[kph]

Thank you very much - it worked and I appreciate your help. I had worked on it for a long time and learned what didn't work - so thanks for the help. kph