i have been given the formula and the inputs as well but ,i dont know how to
give the range of value in the same cell and according to that the value of
formula should gets changed.for example a+b=c,so i managed to get this done
but what if a and b are from 1 to 100.

Put the range of values in separate cells in a column. For example 1 thru 5

1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5
3 1
3 2
3 3
3 4
3 5
4 1
4 2
4 3
4 4
4 5
5 1
5 2
5 3
5 4
5 5


In C1 enter:
=A1+B1 and copy down to display:

1 1 2
1 2 3
1 3 4
1 4 5
1 5 6
2 1 3
2 2 4
2 3 5
2 4 6
2 5 7
3 1 4
3 2 5
3 3 6
3 4 7
3 5 8
4 1 5
4 2 6
4 3 7
4 4 8
4 5 9
5 1 6
5 2 7
5 3 8
5 4 9
5 5 10

--
Gary''s Student - gsnu200748


"krunal" wrote:

i have been given the formula and the inputs as well but ,i dont know how to
give the range of value in the same cell and according to that the value of
formula should gets changed.for example a+b=c,so i managed to get this done
but what if a and b are from 1 to 100.