Fixed Value Dynamic value   Calc Value

100             40             4000

                10  

                30  

                20  

                20  

                40  

I want to calculate all the calc value cell by multiplying Fixed Value with Dynamic Value.

Please help me to write one formula to calculate all the Calc Value Cell.

=$A$2*B2

The above works assuming "Fixed Value" is in cell A1.

The dollar sign before "A" means that it will refer to A even when the formula is dragged to the left/right. The dollar sign before "2" means that it will refer to the second row even when dragged up/down.

You can quickly toggle a reference between fixed and relative for rows/columns by hitting f4 with that reference selected in the formula bar.