Solution – Challenge 28 – Create Pascal’s Triangle

Below is a possible solution to the Challenge 28 – Create Pascal’s Triangle.

Put 1 in L2 and put following formula in C2 and drag right and down.

=IF(IF(B2="",0,B2)+IF(D2="",0,D2)=0,"",IF(B2="",0,B2)+IF(D2="",0,D2))

This will generate following Pascal's Triangle.

To make it better looking, you may use Conditional Formatting.

Select C2 and U11 > Home tab > Conditional Formatting > New Rule > Use a formula to determine which cells to format and put following formula and choose appropriate Fill Colour

=AND(ISNUMBER(B2),ISNUMBER(D2))

This will generate the following Pascal's Triangle

A workbook illustrating the solution can be downloaded from Pascal Triange Solution