|
All 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 in one cell?
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) In article , Jeff wrote: 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 04:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com