Math Is Fun Forum

  Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ -¹ ² ³ °

You are not logged in.

#1 2012-12-19 18:30:37

mathaholic
Member
From: Earth
Registered: 2012-11-29
Posts: 3,251

Math in Excel

Anyone who made anything math in excel? Post them here!
Mine:
Squaring numbers
Type the numbers 1-25 in cells A1-A25. Then, do this formula "=PRODUCT(X,Y), wherein X is cell A1, and Y is also cell A1. After that, copy it, then select column B1. Paste it.
smile


Mathaholic | 10th most active poster | Maker of the 350,000th post | Person | rrr's classmate
smile

Offline

#2 2012-12-19 21:36:36

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,049

Re: Math in Excel

I know that phrontister is an expert in Excel. Maybe he will come here.


“Here lies the reader who will never open this book. He is forever dead.
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

#3 2012-12-19 22:17:35

Bob
Administrator
Registered: 2010-06-20
Posts: 10,053

Re: Math in Excel

hi julianthemath

When I do sudokus I'm always making mistakes like entering an illegal number in a row.  So I made an Excel sheet that puts Xs in the places you cannot go so I could cheat a bit.  I had already done some other stuff on my computer when I started so the memory was down a bit.  Which is probably why I ran out of memory.  eeekkk!  Had to save, re-start and just have Excel running.

Too much to show all here I think.  Here's the contents of just one random cell:

=IF(OR(W3="x",AG3="x",AQ3="x",BA3="x"),"x","")

w3 contains

=IF(HLOOKUP($A$1,$M$2:$U$3,2,FALSE)=1,"x","")

Bob


Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob smile

Offline

#4 2012-12-20 01:58:47

phrontister
Real Member
From: The Land of Tomorrow
Registered: 2009-07-12
Posts: 4,810

Re: Math in Excel

Hi julianthemath,

There are a number of other ways of getting the result you did, but here a couple of easy ones:-

Method 1:

Enter the following into the cells as shown.

A1: 1
A2: =A1^2

Left-click in A1 to select it, and while still holding down the mouse button move the cursor into B1 to select both of them together.
Release the mouse button, but don't click anywhere on the page, otherwise those two cells will be deselected.
Left-click the 'fill-handle' that now appears in the bottom right-hand corner of B1 (it's a black square, which changes to a cross-hair when you hover the mouse over it), and while holding down the left mouse button drag it all the way down column 2 to row 25.
That automatically fills columns 1 and 2 in one go. smile

Method 2:

Enter the following into the cells as shown.

A1: 1
A2: =A1^2

Left-click in A1 to select it.
While holding down the keyboard's Ctrl key, left-click the fill-handle (explained in Method 1) and drag it down column 1 to row 25.
The sequence of numbers 1:25 now appears down the 25 rows in column 1.
Left-click in B1 to select it, and double-left-click the fill-handle to automatically fill column 2 with the formula from B1 for every cell that has data to the left of each column 2 cell.
There...done! smile

And don't let anonimnystefy fool you...I'm no Excel expert! I've learnt a few things over the years by trying this and that, mainly for puzzles and work. Excel has a lot going for it, including the enormous amount of information and help available on the internet.


"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

Offline

#5 2013-03-07 08:25:57

Guest

Re: Math in Excel

I once made a table of the Beta function, but I also had to do one of the Gamma function too because the Beta function uses the Gamma function.
Then I had to make a factorial (or Pi function) table for the Gamma function to work...then I hit the wrong button and lost it all...xD
It is quite fun though making "calculators" with Excel!

#6 2013-04-21 16:01:55

mathaholic
Member
From: Earth
Registered: 2012-11-29
Posts: 3,251

Re: Math in Excel

Thanks everyone. smile


Mathaholic | 10th most active poster | Maker of the 350,000th post | Person | rrr's classmate
smile

Offline

#7 2013-04-21 16:03:58

Agnishom
Real Member
From: Riemann Sphere
Registered: 2011-01-29
Posts: 24,974
Website

Re: Math in Excel

There is probably a lot to learn about excei


'And fun? If maths is fun, then getting a tooth extraction is fun. A viral infection is fun. Rabies shots are fun.'
'God exists because Mathematics is consistent, and the devil exists because we cannot prove it'
I'm not crazy, my mother had me tested.

Offline

#8 2013-04-29 21:14:02

mathaholic
Member
From: Earth
Registered: 2012-11-29
Posts: 3,251

Re: Math in Excel

Oh. Math in Excel 2 soon!


Mathaholic | 10th most active poster | Maker of the 350,000th post | Person | rrr's classmate
smile

Offline

#9 2013-04-29 22:15:55

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,049

Re: Math in Excel

Why not just post here?


“Here lies the reader who will never open this book. He is forever dead.
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

#10 2013-05-05 18:41:27

mathaholic
Member
From: Earth
Registered: 2012-11-29
Posts: 3,251

Re: Math in Excel

Oh, so, math in Excel 2.0 here?


Mathaholic | 10th most active poster | Maker of the 350,000th post | Person | rrr's classmate
smile

Offline

Board footer

Powered by FluxBB