ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   combining Formulas (https://www.excelbanter.com/excel-worksheet-functions/169641-combining-formulas.html)

mndpy

combining Formulas
 
I think I am just not thinking today. So any help would be appreciated.

So my formula is

=(((D3-C3)*1440)-Q8)*(N8/60)

I want to take the answer from this and I want:

c8/(answer)

Yes should be easy but I can't get it to work. Thanks!

David Biddulph[_2_]

combining Formulas
 
What's wrong with =C8/((((D3-C3)*1440)-Q8)*(N8/60))
or C8/(((D3-C3)*1440)-Q8)/(N8/60)
or C8/(((D3-C3)*1440)-Q8)*(60/N8)
or C8*60/N8/(((D3-C3)*1440)-Q8)
or C8*60/(N8*(((D3-C3)*1440)-Q8)) ?
--
David Biddulph

"mndpy" wrote in message
...
I think I am just not thinking today. So any help would be appreciated.

So my formula is

=(((D3-C3)*1440)-Q8)*(N8/60)

I want to take the answer from this and I want:

c8/(answer)

Yes should be easy but I can't get it to work. Thanks!




pdberger

combining Formulas
 
mndpy

Maybe I don't understand you. If this calculation is in B8, and you want
the final answer in D8, can't you just put '=C8/B8' in that cell?

Or, if you're trying to do it all in one cell, can't you just add an extra
set of parentheses around this whole formula as you put it in the denominator?

= C8 / ((((D3-C3)*1440)-Q8)*(N8/60)) ??

Or did I not understand you?

HTH

"mndpy" wrote:

I think I am just not thinking today. So any help would be appreciated.

So my formula is

=(((D3-C3)*1440)-Q8)*(N8/60)

I want to take the answer from this and I want:

c8/(answer)

Yes should be easy but I can't get it to work. Thanks!



All times are GMT +1. The time now is 05:01 PM.

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