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

Login

Username

Password

Not registered yet?

Post a reply

Go back

Write your message and submit
:) :| :( :D :o ;) :/ :P :lol: :mad: :rolleyes: :cool: | :dizzy :eek :kiss :roflol :rolleyes :shame :down :up :touched :sleep :wave :swear :tongue :what :faint :dunno
Options

Go back

Topic review (newest first)

n872yt3r
2013-03-18 00:58:55

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

n872yt3r
2013-03-18 00:43:43

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!

n872yt3r
2013-03-18 00:03:05

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

2013-03-08 07:58:18

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.

Board footer

Powered by FluxBB