hai,
i am a new user. i would like to know the following in excel worksheet.
i have a value in particular cell which is a variable. i would like to multiply the value with a column containing certain values and the product of above shall be displayed in other column.
for example '8' is the variable in one cell.
3
4
5
6
7
are the values in one column.
result shall be
24
32
40
48
56
if i change the variable as '9'
the result shall be
27
36
45
54
63
how to achieve this thro' an excel formula?
can anybody help me?
v.muruganandam
Bookmarks