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.

enter image description here

research absolute , relative cell references more information.


Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -