excel Calculate value based on row and column number in table -
i have table has values @ top of columns , in left margin of rows.
9 10 11 12 13 14 15 16 17 18 19 20 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10
i wish calculate value in cell in table depending on column value , row value cell corresponds to. formula
53 * (column value - row value)
how do that?
with 53 in o2,
=$o$2*(b$1-$a2)
fill right , down.
research absolute , relative cell references more information.
Comments
Post a Comment