Pascals Pyramid with Excel

[CanadaAotS]

For anyone who doesnt know what pascal's pyramid is:

 

1

1,1

1,2,1

1,3,3,1

1,4,6,4,1

1,5,10,10,5,1

etc.

 

So I wanted to make an excel sheet, where the two values diagonally above add up for the value underneath. Is there any easy way of doing this? Something like, all values selected are calculated by value 1 above and to the left plus value 1 above and to the right... or something along those lines.

 

This would be so much easier then doing it for each box seperately.

[Klaynos]

it's not too hard to do, best way might be to leave a gap between each cell with a number in. You can also use an IF statement so the empty boxes are blank.

 

Although there are better ways of calculating the powers.

[CanadaAotS]

Well this is an incredibly old thread of mine, but I'll bump it anyway.

 

What I meant is, do I actually have to code each box as, (for ex)

 

C5=B4+D4

E5=C4+F4

...

 

And so on... I mean, it'd be nice if I could just format all the cells to follow a pattern... or at least make something that's copy-pasteable lol.