i need help making a wooksheet that right to left each column increases by
12.00
and each row going top to bottom with increase by 8.00 so i can go to line
eight and colum, 5 and get the correct total for 8 childrens admissions and 5
adults admissions im not sure if i am explaining this correctly to start
the first box would be 20.oo the sum of column a and row 1 12.00 plus 8.00
i dont know how to configure the formula
help

I assume that you mean increases from left to right, not from right to left?

Try =12*COLUMN()+8*ROW()
--
David Biddulph

"Arizona Angel" <Arizona wrote in message
...
i need help making a wooksheet that right to left each column increases by
12.00
and each row going top to bottom with increase by 8.00 so i can go to
line
eight and colum, 5 and get the correct total for 8 childrens admissions
and 5
adults admissions im not sure if i am explaining this correctly to start
the first box would be 20.oo the sum of column a and row 1 12.00 plus
8.00
i dont know how to configure the formula
help

Some thoughts illustrated in this sample construct:
http://www.savefile.com/files/625370
Pricing Table n Retrievals w CF visual.xls

Set-up Pricing Table
With unit prices entered in D17:D18,
and the # of adults/child listed in C2:L2, B3:B12,
Put in C3: =SUM(C$2*$D$17,$B3*$D$18)
Copy C3 across/down to L12 to populate the pricing table

Retrieve from Pricing Table
With the # of adults & child selected in C23:D23,
To retrieve the total price from the pricing table
Put in E23:
=INDEX($B$2:$L$12,MATCH(D23,$B$2:$B$12,0),MATCH(C2 3,$B$2:$L$2,0))

Accompanying CF visual (in the Table)
The conditional formatting "visual aid" is effected via selecting B2:L12
(with B2 active) then applying the formula (via Formula is:):
=AND(MATCH($D$23,$B2:$L2,0),MATCH($C$23,B$2:B$12,0 ))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arizona Angel" wrote:
i need help making a wooksheet that right to left each column increases by
12.00
and each row going top to bottom with increase by 8.00 so i can go to line
eight and colum, 5 and get the correct total for 8 childrens admissions and 5
adults admissions im not sure if i am explaining this correctly to start
the first box would be 20.oo the sum of column a and row 1 12.00 plus 8.00
i dont know how to configure the formula
help