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
 

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

Back
Top