# Excel Investigation: Pythagorean Triples

##### Age 11 to 16Challenge Level

The formula for the first cell is =SQRT(B$1^2+$A2^2) which is then copied across the chosen range. Then look for cells in which this formula returns integer values. Conditional formatting helps identify the values of interest. The colour change occurs when a cell value is exactly equal to its integer part. The red type on a tan background are genuine integers, and are the result of the conditional formatting being activated. The other integers in the sheet are caused by Excel rounding the display value to 2 digits even though the held value may have many decimal places, as increasing the width of a column would reveal.