[FONT="]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 p.s. here is a link to the spreadsheet I assure you it is NOT malicious. http://phoenixsequence.com/misc/magic_square.xlsx[/FONT] |