Results 1 to 6 of 6

Thread: Help with explaining this formula, Please
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2007
    Location
    Valdost Ga.
    Posts
    346
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help with explaining this formula, Please

    With this formula, why canít I use the cell example (F7), instead of (65%), when F7 = 10% is where it is?

    It gives me the correct answer written this way.

    Code:
    =ROUND((A2+10%*A2)/65%,2)
    Thanks in advance.
    The one thing that never changes.

    "EVERY THING CHANGES"

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,068
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    48 Thread(s)

    Default Re: Help with explaining this formula, Please

    How about
    =ROUND((A2*1.1)/F2,2)
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,745
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Help with explaining this formula, Please

    Excel 2010
    ABCDE
    110%65%
    21,000.001,692.311,692.31
    3

    3b



    Worksheet Formulas
    CellFormula
    B2=ROUND((A2+10%*A2)/65%,2)
    C2=ROUND((A2+D1*A2)/E1,2)




    What are your trying to calculate?
    What is the correct answer?
    Did you try using Excel's Formula Evaluate?

  4. #4
    Board Regular
    Join Date
    Mar 2014
    Posts
    2,484
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Help with explaining this formula, Please

    Quote Originally Posted by Get_Involved View Post
    With this formula, why can’t I use the cell example (F7), instead of (65%), when F7 = 10% is where it is?
    It gives me the correct answer written this way.
    =ROUND((A2+10%*A2)/65%,2)
    We don't know; you tell us(!). After 345 posts, I think that you should know how to ask a question about formula behavior by now, in order to get the quickest and most applicable response.

    At a minimum, explain "why can't I?". Do you get an Excel error (e.g. #VALUE ); if so, which one? Do you simply get an unexpected result; if so, what value? Show us your original formula; the one that does not work. And show us all values, ideally displayed with up to 15 significant digits. Copy-and-paste the formula from the Formula Bar. If you retype it into your posting, you might inadvertently correct the mistake that you have in the Excel file.

    IF F7 is 10%, obviously you cannot use F7 in place of 65%.

    If F7 is 10% and G7 is 65%, you could write simply:

    =ROUND(A2*(1+F7)/G7, 2)
    Last edited by joeu2004; Sep 22nd, 2019 at 01:55 PM.

  5. #5
    Board Regular
    Join Date
    Jan 2007
    Location
    Valdost Ga.
    Posts
    346
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with explaining this formula, Please

    thanks for your help solved
    The one thing that never changes.

    "EVERY THING CHANGES"

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,068
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    48 Thread(s)

    Default Re: Help with explaining this formula, Please

    Glad we could help & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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