combining Formulas

  • Thread starter Thread starter mndpy
  • Start date Start date
M

mndpy

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!
 
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)) ?
 
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
 
Back
Top