CODEWITHSUNDEEP
excelexcel-formula
user3448916
user3448916

Reputation: 1

Solving a math equation in excel through two variables

w=[1/mn(m^2+n^2)^2)]{sin(m*pi/2)sin(n*pi/2)}

where m and n varies from 1 to 11.

for m=1, n=1,3,5,7,9,11.
for m=2, n=1,3,5,7,9,11.
for m=3, n=1,3,5,7,9,11.
and so on.

Instead of 36 sets of combinations, I need one formula to calculate the set of these 36 combinations and get respective values of w.

Please help me with this equation. I need to solve it in excel.

P.S I'm beginner.

Upvotes: 0

Views: 1597

Answers (1)

Sourabh Bhat
Sourabh Bhat

Reputation: 1893

You may create column and rows with heading values of n and m respectively, and calculate the value of w at their intersection. For auto-completion of formula by dragging, you will have to use $ symbol for referencing. See the representation below:

m\n    1        3         5        7        9        11
1    w(1,1)   w(1,3)    w(1,5)   w(1,7)  w(1,9)    w(1,11)
2    w(2,9)   w(3,9) ... so on
3    ...
4
5
6
.
.

Instead of numbers above in w(m,n) use references of column while dragging with a $ sign so that the header row does not change.

EDIT: You need to type the formula only once in at the intersection of (1,1)

Upvotes: 1

Related Questions