programming with excel
programming with excel
How do you generate codes using excel?
Binomial Theorem: ((a+b)^n)= sum k=0->k=n((n!(a^(n-k))(b^k))/(k!(n-k)!))
-
- Posts: 523
- Joined: Mon Jun 03, 2013 4:54 pm
Re: programming with excel
Use the if statement. The rest is trial and error.
(You don't even need the if statement!)
Also try turning on iterative calculations. This is very inconsistent though.
This forum doesn't allow .xlsx attachments though, so I can't attach any of the stuff I've made.
Andy, could you try allowing .xlsx?

Also try turning on iterative calculations. This is very inconsistent though.
This forum doesn't allow .xlsx attachments though, so I can't attach any of the stuff I've made.
Andy, could you try allowing .xlsx?
$1 = 100¢ = (10¢)^2 = ($0.10)^2 = $0.01 = 1¢ [1]
Always check your units or you will have no money!
Always check your units or you will have no money!
Re: programming with excel
You can do programming with excel? Well don't that beat all, I gotta try that out.
19683 (it would be much easier to just call you numbers), you can just upload your stuff into a website like, say, mediafire I believe.
19683 (it would be much easier to just call you numbers), you can just upload your stuff into a website like, say, mediafire I believe.
Convincing people that 0.9999... = 1 since 2012
-
- Posts: 523
- Joined: Mon Jun 03, 2013 4:54 pm
Re: programming with excel
Nah, without the VBA it's not easy to do 3+d arrays. In fact even control structure isn't straightforward - It's more like a Turing machine or cellular automaton than a programming language.robly18 wrote:You can do programming with excel? Well don't that beat all, I gotta try that out.
19683 (it would be much easier to just call you numbers), you can just upload your stuff into a website like, say, mediafire I believe.
Oh and mediafire isn't very safe sometimes, even if you click the right link. I'd recommend describing the things in the cells, or waiting for Andy to enable .xlsx.
$1 = 100¢ = (10¢)^2 = ($0.10)^2 = $0.01 = 1¢ [1]
Always check your units or you will have no money!
Always check your units or you will have no money!
- testtubegames
- Site Admin
- Posts: 1164
- Joined: Mon Nov 19, 2012 7:54 pm
Re: programming with excel
Added! (I think)A Random Player wrote:I'd recommend describing the things in the cells, or waiting for Andy to enable .xlsx.
-
- Posts: 523
- Joined: Mon Jun 03, 2013 4:54 pm
Re: programming with excel
Yep, it works! Here's one of mine: First, enable editing. If it errors with "circular reference", try closing any other excel spreadsheets. To use it, set A1 to the number to the number to be factored, and set B1 to 0, then 1. Hold F9, and wait.testtubegames wrote:Added! (I think)A Random Player wrote:I'd recommend describing the things in the cells, or waiting for Andy to enable .xlsx.
$1 = 100¢ = (10¢)^2 = ($0.10)^2 = $0.01 = 1¢ [1]
Always check your units or you will have no money!
Always check your units or you will have no money!
Re: programming with excel
Seems like it feels a lot like some of them first computers.
Do want.
Do want.
Convincing people that 0.9999... = 1 since 2012