All in one cell?

J

Jeff

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
 
J

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top