LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I fill a formula on another sheet that repeat every 50 cell Chad Hable Excel Discussion (Misc queries) 2 December 31st 07 11:14 PM
How do I fill a formula on another sheet that repeat every 50 cell Chad Hable[_2_] Excel Worksheet Functions 3 December 31st 07 07:35 PM
looking for a way to repeat a formula pattern within a cell dla Excel Worksheet Functions 3 February 2nd 07 09:09 AM
Repeat Cell Formula w/out copy/paste? DTTODGG Excel Discussion (Misc queries) 1 March 13th 06 05:11 PM
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec unibaby Excel Discussion (Misc queries) 2 August 24th 05 04:29 PM


All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"