[Wolfeymole]

Demo send a sample in .xls format to MYUSERNAME@thecomputerforums.co.uk

[grush]

Originally Posted by hAvAAck

so you might have
A1 = cost price
A2 = VAT
A3 = markup percentage

and B1 is the full price, or whatever you're looking for
and it would be = (A1 + A2 + (A1*A3))
and you could drag it down the entire column? Where A1 might change but A2 and A3 would remain stationary until you manually changed them?
Or did I jump the boat?

a1=cost
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

[Wolfeymole]

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.

[grush]

Wolfeymole this is getting annoying it should be simple.

[Wolfeymole]

Yes i know mate.

[demo]

Hi wolfeymole
did you get my sample matrix

[Wolfeymole]

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?

[demo]

sent to myusername@thecomputerforums.co.uk if i should have put wolfeymole@ then i appoligise for being thick

[PranX]

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

[demo]

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