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

You are not logged in. #1 20130308 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 20130318 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 (20130318 00:44:21)  n872yt3r Math Is Fun Rocks! By the power of the exponent, I square and cube you! #5 20130814 05:25:16
Re: Excel CalculatorsI 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. 