Math Is Fun Forum

∞

Guest

Excel Calculators

Have you ever tried using Excel to make calculators? By that I mean like formulas that when you imput a value, it solves the formula for you and gives you the answer. If you have, I would appreciate it if you could post them here so I could try them. Thanks! If I figure out one, I will let you know.

n872yt3r

Member

Registered: 2013-01-21

Posts: 392

Re: Excel Calculators

I'm making one right now... when it's finished I'll tell you all the code.

---

- n872yt3r
Math Is Fun Rocks!
By the power of the exponent, I square and cube you!

n872yt3r

Member

Registered: 2013-01-21

Posts: 392

Re: Excel Calculators

Ok,

, it's ready.
Let's go cell by cell.
A1: Addition
A2: Enter the first addend in A3:
A3:
A4: Enter the second addend in A5:
A5:
A6: The sum is:
A7: =SUM(A3,A5)
B1: Subtraction
B2: Enter the minuend in B3:
B3:
B4: Enter the subtrahend in B5:
B5:
B6: The difference is:
B7: IMSUB(B3,B5)
C1: Multiplication
C2: Enter the first factor in C3:
C3:
C4: Enter the second factor in C5:
C5:
C6: The product is:
C7: =PRODUCT(C3,C5)
D1: Division
D2: Enter the dividend in D3:
D3:
D4: Enter the divisor in D5:
D5:
D6: The quotient is:
D7: =QUOTIENT(D3,D5)
E1: Factorial
E2: Enter the number in E3:
E3:
E4:
E5:
E6: The factorial is:
E7: =FACT(E3)
F1: GCF
F2: Enter the first number in F3:
F3:
F4: Enter the second number in F5:
F5:
F6: The GCF is:
F7: =GCD(F3,F5)
G1: LCM
G2: Enter the first number in G3:
G3:
G4: Enter the second number in G5:
G5:
G6: The LCM is:
G7: =LCM(G3,G5)
H1: Natural Logarithm
H2: Enter the number in H3:
H3:
H4:
H5:
H6: The natural logarithm is:
H7: =LN(H3)
I1: Exponent
I2: Enter the number in I3:
I3:
I4: Enter the exponent in I5:
I5:
I6: The standard value is:
I7: =POWER(I3,I5)
J1: Sine
J2: Enter the angle in J3:
J3:
J4:
J5:
J6: The sine is:
J7: =SIN(J3)
K1: Cosine
K2: Enter the angle in K3:
K3:
K4:
K5:
K6: The cosine is:
K7: =COS(K3)
L1: Tangent
L2: Enter the angle in L3:
L3:
L4:
L5:
L6: The tangent is:
L7: =TAN(L3)
M1: Square Root
M2: Enter the number in M3:
M3:
M4:
M5:
M6: The square root is:
M7: =SQRT(M3)
Phew!

Last edited by n872yt3r (2013-03-17 01:44:21)

---

- n872yt3r
Math Is Fun Rocks!
By the power of the exponent, I square and cube you!

n872yt3r

Member

Registered: 2013-01-21

Posts: 392

Re: Excel Calculators

To download the file, go to http://www.adastralab.com/2013/03/17/excel-calculator/

---

- n872yt3r
Math Is Fun Rocks!
By the power of the exponent, I square and cube you!

∞

Guest

Re: Excel Calculators

I finally got a chance to work on mine; all it has is the 4 boring algebra operations: addition, subtraction, division, and multiplication. Unfortunately, my previous one that had factorial function, Pi function, Gamma function, Beta function, and possibly the integer function (if im thinking of the right one) was accidentally dragged into my Recycle Bin! xD Thanks for showing me yours! Im definitely am going to have to add some of those functions into mine and check out your file.