HELP!! - Need Formula to fill in the missing cells

aneikei

New member
Joined
Oct 12, 2016
Messages
2
[FONT=&quot]In the spreadsheet are two math squares both are the same except the bottom has the center results missing. I need a formula to calculate them back one cell at a time using the given info. The row and columns add up vertical and horizontally giving a total of 25022486. Using the given info of the total sum and the individual sums of the row and columns I would like to a method to regenerate the center cells.

Thank you

Tony

attachment.php


p.s. here is a link to the spreadsheet I assure you it is NOT malicious.

http://phoenixsequence.com/misc/magic_square.xlsx[/FONT]
 

Attachments

  • math_square.JPG
    math_square.JPG
    115.5 KB · Views: 19
Top