Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining formulas | Excel Discussion (Misc queries) | |||
Combining 2 Formulas | Excel Discussion (Misc queries) | |||
Combining Two Formulas to One | Excel Discussion (Misc queries) | |||
combining formulas | Excel Discussion (Misc queries) | |||
Combining 2 Formulas | Excel Worksheet Functions |