+ Reply to Thread
Results 1 to 3 of 3

When I enter values in INPUT Formulas calculate in OutPut

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    When I enter values in INPUT Formulas calculate in OutPut

    Hi,

    I have received a screenshot, I want to know when I put values in INPUT, how value come in OUTPUT, I mean what is the formula, please check the screenshot.
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: When I enter values in INPUT Formulas calculate in OutPut

    Probably using Brzycki formula for calculating 1RM.

    1RM ≈ w/(1.0278-0.0278*r)

    Where...
    w is the amount of weight used (factor for the formula and unit does not matter).
    r is the number of repetition performed.

    So...
    1RM ≈ 100/(1.0278-0.0278*10)
    1RM ≈ 133.3689

    Edit: See wiki for more details on 1RM calculation formulas.
    https://en.wikipedia.org/wiki/One-repetition_maximum

    Also if you want more accurate result use...
    1RM =w/(37/36-(1/36*r))
    Last edited by CK76; 02-01-2017 at 12:39 PM. Reason: See Edit:

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: When I enter values in INPUT Formulas calculate in OutPut

    Thank you Mr CK76, you are genius.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Display values based on input / output table
    By zdimitrov in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2015, 09:12 PM
  2. Need to enter symbol, run macro, then paste output as values
    By smcmahon83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2015, 12:41 AM
  3. [SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values
    By faby2203 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2013, 07:05 AM
  4. [SOLVED] Look for values in sheet1 (input) and paste output in dedicated cells in sheet2
    By dnlwstr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 06:38 AM
  5. Need macro to loop through input cell values and copy output value
    By jaf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 02:59 PM
  6. Input/output values into/from an array
    By Brane Ded in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 11-18-2009, 09:11 PM
  7. Calculate output for the logic in the attached spreadhseet based on user input
    By tenn0228 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2009, 10:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1