200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
how to calculate fixed one cell to many cells by using formula?
How to calculate the value of a single cell from the cell value of the different columns by formula?
for exp.: i want multiply cell "A1" to any column's cell value, but repeat above cell A1
=B1*A1
=B3*A1
=B5*A1
=B7*A1
what formula this condition?
Shall I then copy paste the formula in the cell of the fold.
pl z guide me.
I believe that you may be looking for an Absolute Reference? if in your formula you hit the F4 key that will turn on absolute references. In your example, I would...type the "=" then point to cell B1, then use the asteric " * " for the multiplication, then point to cell A1 and hit the F4 key one time (this will place dollar signs "$" before the row and Column) the completed formula would look like = B1 * $A$1 which could e copied to another cell and it would always reference A1 in the formula. Please look at Excel's help or google Absolute and Relative cell references for additional info (and probably a better explanation ~ but that is the best way to learn it too!)
