All in one cell?

[Guest]

How can I do this in one cell?
D8=12, E8=12 and H8=11.75 and I need K8 to =15.389
This is what I have in K8 so far =60/(D8*E8/H8) Answer=â€4.896â€
But then I want to dived 75/ â€4.896†+.07 =15.389 in K8

I know could just use another cell “K9†for example…
in K9 “=75/K8+.07†Answer= 15.389
but I prefer to keep it all in K8 if possible.

Thank you,
Jeff

 

[JE McGimpsey]

One way:

K8: =75/(60/(D8*E8/H8))+0.07

or simplifying:

K8: =1.25*D8*E8/H8+0.07

Or, if you want only 3 decimals:

K8: =ROUND(1.25*D8*E8/H8+0.07,3)