how do i use range of value in same cell example 1 to 100
 

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.

how do i use range of value in same cell example 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.