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

You are not logged in.

- Topics: Active | Unanswered

Pages: **1**

**∞****Guest**

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

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!

Offline

**n872yt3r****Member**- Registered: 2013-01-21
- Posts: 392

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!

Offline

**n872yt3r****Member**- Registered: 2013-01-21
- Posts: 392

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!

Offline

**∞****Guest**

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.

Pages: **1**