HELP HELP with excel formulas

[Guest]

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

 

[David Biddulph]

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

Try =12*COLUMN()+8*ROW()

 

[Guest]

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 D1718,
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 C2323,
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(C23,$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))