Four corner pricing grid....please help :(

**casey63** · 04-01-2012, 04:06 PM

Four corner pricing grid.....please help

Hi everyone. There are some very clever people on here and therefore I really hope someone can help with a problem I have. I need to produce around 50 price matrix for differant window styles, but the thing is I want in some way to substantially reduce the time by having a system of 'four corner pricing' ie i just manually input a price in the four corners of each matrix and the rest of the prices are automatically calculated based on my manual figures. It seems incredibly complicated to me but hoping its possible. Ive attached a sample sheet with the manual prices shown purely for this example.

**Richard Buttrey** · 04-01-2012, 05:20 PM

Hi,

You weren't very explicit as to what you want to see. Some manually calculated results would have been useful. However assuming everything is pro rata then

C3: =(C$11-C$2)/9+C2 copied down to C10
L3: =(L$11-L$2)/9+L2 copied down to L10
D2: =($L2-$C2)/9+C2 copied to D2:K11

Regards