Discussion about math, puzzles, games and fun. Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ -¹ ² ³ °
| |
|
|
You are not logged in. #1 2013-03-08 07:58:18
Excel CalculatorsHave 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. #3 2013-03-18 00:43:43
Re: Excel CalculatorsOk, , 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-18 00:44:21) - n872yt3r Math Is Fun Rocks! By the power of the exponent, I square and cube you! |