Hello All,
I have 10 rows of calculation and its simple first cell A1 which is provided by default From here cell A2 should be multiplied by 2 of A1 and cell A3 by 3 of A1 and A10 to be multiplied by 10 of A1. I wrote a function =A1*2 in cell A2 but problem here is when I click on the cell I see the formula and not the number (which is required for me as I will be copying and pasting this to other sheet) , so what I do is write the formula else where and copy and paste as value. This takes alot of time , is there a simpler solution for example where I can write formula in A2 and Drag the formula all the way down.
thanks
Raj
Bookmarks