View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default HELP HELP with excel formulas

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