ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I do this in one cell? (https://www.excelbanter.com/excel-discussion-misc-queries/145340-how-can-i-do-one-cell.html)

Jeff

How can I do this in one cell?
 
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


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com