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 |
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) |