Jump to content

Pascals Pyramid with Excel


CanadaAotS
 Share

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 6 months later...

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.