| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat formula within a cell
Please help !!
I need a simple way to repeat some parts of a forula within a cell. We are selling products which are priced pr millimeter, and we calculate totale value of goods in stock. The formula collect mm price from one sheet-- mulitiply with actual width--multiply with quantity of each width. Example of structue 10 20 30 40 45 48 Total value 2 546 321 21 654 546 325.213 The actual formula I currently use: =((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+( (Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser! E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8 *$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$ P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$ 7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7) *$T11)+((Priser!E8*$U$7)*$U11) The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells. Please help me find a solution for this formula, and simplify my world.... Best regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat formula within a cell
Not sure what you want, but your formula can be simplified
=SUMPRODUCT($B$7:$U$7*E8*$B11) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Håvard Spaniland" wrote in message ... Please help !! I need a simple way to repeat some parts of a forula within a cell. We are selling products which are priced pr millimeter, and we calculate totale value of goods in stock. The formula collect mm price from one sheet-- mulitiply with actual width--multiply with quantity of each width. Example of structue 10 20 30 40 45 48 Total value 2 546 321 21 654 546 325.213 The actual formula I currently use: =((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+( (Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser! E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8 *$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$ P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$ 7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7) *$T11)+((Priser!E8*$U$7)*$U11) The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells. Please help me find a solution for this formula, and simplify my world.... Best regards |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat formula within a cell
Thanks Bob.
Please se example at this file http://www.sto-nor.no/hjelp.xls - håvard - "Bob Phillips" wrote: Not sure what you want, but your formula can be simplified =SUMPRODUCT($B$7:$U$7*E8*$B11) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Håvard Spaniland" wrote in message ... Please help !! I need a simple way to repeat some parts of a forula within a cell. We are selling products which are priced pr millimeter, and we calculate totale value of goods in stock. The formula collect mm price from one sheet-- mulitiply with actual width--multiply with quantity of each width. Example of structue 10 20 30 40 45 48 Total value 2 546 321 21 654 546 325.213 The actual formula I currently use: =((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+( (Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser! E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8 *$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$ P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$ 7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7) *$T11)+((Priser!E8*$U$7)*$U11) The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells. Please help me find a solution for this formula, and simplify my world.... Best regards |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat formula within a cell
Hi Håvard,
How about this =SUMPRODUCT($B$1:$U$1,$B2:$U2)*Priser!B2 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) " Spaniland" wrote in message ... Thanks Bob. Please se example at this file http://www.sto-nor.no/hjelp.xls - håvard - "Bob Phillips" wrote: Not sure what you want, but your formula can be simplified =SUMPRODUCT($B$7:$U$7*E8*$B11) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Håvard Spaniland" wrote in message ... Please help !! I need a simple way to repeat some parts of a forula within a cell. We are selling products which are priced pr millimeter, and we calculate totale value of goods in stock. The formula collect mm price from one sheet-- mulitiply with actual width--multiply with quantity of each width. Example of structue 10 20 30 40 45 48 Total value 2 546 321 21 654 546 325.213 The actual formula I currently use: =((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+( (Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser! E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8 *$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$ P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$ 7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7) *$T11)+((Priser!E8*$U$7)*$U11) The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells. Please help me find a solution for this formula, and simplify my world.... Best regards |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat formula within a cell
Thanks once a again Bob,
You're my new super-hero. I only need to change some minor things. I use a Norwegian version, therefore the name was incorrect. The 100% working code he =SUMMERPRODUKT(($B$1:$U$1);($B2:$U2))*Priser!B2 "Bob Phillips" wrote: Hi Håvard, How about this =SUMPRODUCT($B$1:$U$1,$B2:$U2)*Priser!B2 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) " Spaniland" wrote in message ... Thanks Bob. Please se example at this file http://www.sto-nor.no/hjelp.xls - håvard - "Bob Phillips" wrote: Not sure what you want, but your formula can be simplified =SUMPRODUCT($B$7:$U$7*E8*$B11) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Håvard Spaniland" wrote in message ... Please help !! I need a simple way to repeat some parts of a forula within a cell. We are selling products which are priced pr millimeter, and we calculate totale value of goods in stock. The formula collect mm price from one sheet-- mulitiply with actual width--multiply with quantity of each width. Example of structue 10 20 30 40 45 48 Total value 2 546 321 21 654 546 325.213 The actual formula I currently use: =((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+( (Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser! E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8 *$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$ P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$ 7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7) *$T11)+((Priser!E8*$U$7)*$U11) The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells. Please help me find a solution for this formula, and simplify my world.... Best regards |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat formula within a cell
Thanks Håvard, I will don my cape <g.
I had assumed you were using Norwegian version of Excel, and I thought about translating it, but as you had posted in English I thought you were comfortable with this aspect. By the way, some of those brackets are superfluous =SUMMERPRODUKT($B$1:$U$1;$B2:$U2)*Priser!B2 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Håvard Spaniland" wrote in message ... Thanks once a again Bob, You're my new super-hero. I only need to change some minor things. I use a Norwegian version, therefore the name was incorrect. The 100% working code he =SUMMERPRODUKT(($B$1:$U$1);($B2:$U2))*Priser!B2 "Bob Phillips" wrote: Hi Håvard, How about this =SUMPRODUCT($B$1:$U$1,$B2:$U2)*Priser!B2 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) " Spaniland" wrote in message ... Thanks Bob. Please se example at this file http://www.sto-nor.no/hjelp.xls - håvard - "Bob Phillips" wrote: Not sure what you want, but your formula can be simplified =SUMPRODUCT($B$7:$U$7*E8*$B11) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Håvard Spaniland" wrote in message ... Please help !! I need a simple way to repeat some parts of a forula within a cell. We are selling products which are priced pr millimeter, and we calculate totale value of goods in stock. The formula collect mm price from one sheet-- mulitiply with actual width--multiply with quantity of each width. Example of structue 10 20 30 40 45 48 Total value 2 546 321 21 654 546 325.213 The actual formula I currently use: =((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+( (Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser! E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8 *$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$ P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$ 7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7) *$T11)+((Priser!E8*$U$7)*$U11) The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells. Please help me find a solution for this formula, and simplify my world.... Best regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I fill a formula on another sheet that repeat every 50 cell | Excel Discussion (Misc queries) | |||
| How do I fill a formula on another sheet that repeat every 50 cell | Excel Worksheet Functions | |||
| looking for a way to repeat a formula pattern within a cell | Excel Worksheet Functions | |||
| Repeat Cell Formula w/out copy/paste? | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Hybrid Mode
