![]() |
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! |
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! |
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