![]() |
|
#11
| |||
| |||
| Demo send a sample in .xls format to MYUSERNAME@thecomputerforums.co.uk |
|
#12
| |||
| |||
| Quote:
a2 =a1+%increase a3 =a1+a2+67.5%(total price inc markup & vat) a1+a2 would then need to become the new A1 ready for the next increase, Its the last bit I get stuck on |
|
#13
| |||
| |||
| This scenario may not yield the correct answer Grush as mathematical logic dictates the the figures in brackets will be calculated first. Let's wait for an example from Demo. |
|
#14
| |||
| |||
| Wolfeymole this is getting annoying it should be simple. |
|
#15
| |||
| |||
| Yes i know mate. |
|
#16
| |||
| |||
| Hi wolfeymole did you get my sample matrix |
|
#17
| |||
| |||
| I did not Demo, please allow me 5 minutes on this as to why the email address I provided was altered. What address did you send to? |
|
#18
| |||
| |||
| sent to myusername@thecomputerforums.co.uk if i should have put wolfeymole@ then i appoligise for being thick |
|
#19
| |||
| |||
| Hey Demo If I read your question correctly I would do as I have shown below: A B C D E F G 1 B.C.P.R 1: 100 A.C.P.R 1 101 R.P.Ra 1 151,5 2 B.C.P.R 2: 120 A.C.P.R 2 121,2 R.P.Ra 2 181,8 3 B.C.P.R 3: 140 A.C.P.R 3 141,4 R.P.Ra 3 212,1 4 B.C.P.R 4 160 A.C.P.R 4 161,6 R.P.Ra 4 242,4 5 ... ... ... ... ... ... 6 Percentchange in costprice: 1% 7 8 Percent increase for retail: 50% Cell C1 has the basic costprice no formulaes unless you have a method to figure that out Cell E1 reads "=C1+(C1*D6)" Without the "" Cell G1 reads "=E1+(E1*D8)" Again without the "" Type in c2, e2, g2,c3,c4,g4 etc. In the same structure as shown above. In cell D6 and D8 you will have to change the format of the cell to %, you do that by pushing the button % in the toolbelt or by right clicking on the cells/cell format/Percent (and choose how many decimals you want). If you type that into an excel spreadsheet you wil be able to: Change the Actual Costprice by altering D6 Change percent increase for retail by altering D8 B.C.P.R = Basic Costprice Range... A.C.P.R = Actual Costprice Range... R.P.Ra = Retail Price Range... (I shortened it to make it fit in this boks so you can see the cell names...) If you are fancy you can use Autopost but then you have to lock some of the cellreferences. You do that by putting an $ in front of the reference you want to lock. If you wanna do that Cell E1 should read "=C1+(C1*$D$6)" .... Without the "" And Cell G1 should read "=E1+(E1*$D$8)" .... Without the "" Okay.. I Hope I answered you question :) I tried to do it as simple as i possibly could! When i posted it the layout got a big messy. A,B,C,D,E,F and G where supposed to be over the cells... Hmm Like this: A should be over 1 , B should be over B.C.P.R 1 , C should be over 100 , D should be over A.C.P.R 1 , E should be over 101 , F should be over R.P.Ra and G should be over 151,5[/B] Best Regards and Good Luck: PranX |
|
#20
| |||
| |||
| hi pranX thanks for taking an interest. due to a recent death in the family i have not been working on this problem recently. just starting to get back to the task but gratefull for your sugestion thanks demo |
![]() |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Images Wont Load when I Open MS Works Spreadsheet | dgriff | Office Suites & Applications | 0 | 24th Aug 2009 05:04 |
| Excel Spreadsheet Showing Hashes Instead of Dates | VJH | Office Suites & Applications | 4 | 12th Aug 2009 15:00 |
| Which spreadsheet software to use? | BattyBirdWoman | Office Suites & Applications | 4 | 20th Apr 2008 09:20 |
| Urgent Help needed with Spreadsheet | CharlesCrisp | Office Suites & Applications | 2 | 6th Jan 2008 14:58 |
| Hey all, help needed | robk89 | General Hardware Chat | 14 | 21st Nov 2007 10:53 |
| Thread Tools | |
| |