Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
Hi
Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
Like this:
=F262*FG262-(SUM(H262:H268)-H269)*G262 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
one question Fg is refering to the part 2?
"carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
I think you still haven't understood the SUM function. Please look up the
SUM function in excel help ? Are you sure that =sum((H262:H268)-H269)*G262 works for you? [Or does it give a #VALUE! error?] Doesn't it only work if you enter it as an array formula (Control Shift Enter)? Did you mean =(sum(H262:H268)-H269)*G262 (which gives a different answer from the array formula) ? In which case combining the formulae gives =(F262*Fg262)-(sum(H262:H268)-H269)*G262 ? -- David Biddulph "carol" wrote in message ... Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
Sorry, that is a typo - it should be G262 (and yes, the same cell as it part 2)
"alexrs2k" wrote: one question Fg is refering to the part 2? "carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
Taking in consideration the two formulas you provide there's no way to
combine them, since they do not depend on each other, no matter they have a common G262. "carol" wrote: Sorry, that is a typo - it should be G262 (and yes, the same cell as it part 2) "alexrs2k" wrote: one question Fg is refering to the part 2? "carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
Does this not work?
=F262*G262-(SUM(H262:H268)-H269)*G262 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "carol" wrote: Sorry, that is a typo - it should be G262 (and yes, the same cell as it part 2) "alexrs2k" wrote: one question Fg is refering to the part 2? "carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
Yes it does - thanks.
"Luke M" wrote: Does this not work? =F262*G262-(SUM(H262:H268)-H269)*G262 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "carol" wrote: Sorry, that is a typo - it should be G262 (and yes, the same cell as it part 2) "alexrs2k" wrote: one question Fg is refering to the part 2? "carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
As far as I understand she wants to combine the formula through the common
cell G262, not to subtract them. -- Alex *Remember to click "yes" if this post helped you. Thank you! "Luke M" wrote: Does this not work? =F262*G262-(SUM(H262:H268)-H269)*G262 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "carol" wrote: Sorry, that is a typo - it should be G262 (and yes, the same cell as it part 2) "alexrs2k" wrote: one question Fg is refering to the part 2? "carol" wrote: Hi Thanks for all your help earlier. I have another set of cells that i need to combine into one as follows: 1) (F262*Fg262) 2) =sum((H262:H268)-H269)*G262 Can someone tell me how to combine the above to take away the answer of part 2 from part 1? Many thanks Carol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining formulas | Excel Worksheet Functions | |||
combining formulas | Excel Discussion (Misc queries) | |||
Combining formulas | Excel Discussion (Misc queries) | |||
combining two formulas | Excel Worksheet Functions | |||
Combining 2 Formulas | Excel Worksheet Functions |