+ Reply to Thread
Results 1 to 6 of 6

Using Formula Results in Another Formula

  1. #1
    Registered User
    Join Date
    02-08-2018
    Location
    Colorado
    MS-Off Ver
    2016
    Posts
    3

    Using Formula Results in Another Formula

    I have a simple Excel spreadsheet with a basic multiplication equation in one column, and I'm trying to have the resulting product (rounded to an integer) used in the 3rd column as part of abasic division problem.

    Column A - An integer
    Column B - Multiplication with product showing as an integer as it's a number cell with no decimal

    No matter how I've tried setting up the formula in column C using the results of column B, it always just gives me 17% (the .17 part of the formula in column B). It doe

    I can manually type each cell for column C based on the rounded to an integer result of column B, ie., =3/15, but I want to fill numerous cells automatically using a formula based on as little user input as possible...if possible. No matter what I try, the results in C always show up as .17, completely blowing my mind.

    Column A Column B Column C
    15 =15*.17 =B/A

    No matter what, Column C gives me .17, or 17% since I have it set for a percentage.

    Thanks much for any assistance! Michael

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,789

    Re: Using Formula Results in Another Formula

    Welcome to the forum!

    What is the formula you are using?

    A sample workbook would speak 1000 words!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Using Formula Results in Another Formula

    I'm not sure I understand.

    What exactly is in column B? If the given formula is exactly what is in column B, then I think you need to add a ROUND() function to it. Formatting a cell to display only whole numbers changes the displayed value, but does not change the actual value stored in the cell. The cell may display 3, but the actual value is 2.55, and 2.55/15 will be 17%. However, if B i =ROUND(A1*0.17,0), then the actual value in column B will be 3, and 3/15 will be 20%.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    02-08-2018
    Location
    Colorado
    MS-Off Ver
    2016
    Posts
    3

    Re: Using Formula Results in Another Formula

    Thanks MrShorty!

    That's exactly what I needed. Driving myself crazy over this. Thanks again.

  5. #5
    Registered User
    Join Date
    02-08-2018
    Location
    Colorado
    MS-Off Ver
    2016
    Posts
    3

    Re: Using Formula Results in Another Formula

    Copying out to my Excel notes so I don't have to ask the same question again in the future.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,789

    Re: Using Formula Results in Another Formula

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Replies: 2
    Last Post: 08-24-2014, 04:56 AM
  2. Replies: 6
    Last Post: 04-25-2014, 10:31 AM
  3. Replies: 3
    Last Post: 06-19-2013, 03:40 AM
  4. Formula required to hide results from another cell formula
    By 917 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2013, 12:12 AM
  5. Replies: 14
    Last Post: 06-27-2012, 04:26 PM
  6. Replies: 11
    Last Post: 04-14-2011, 05:07 PM
  7. Replies: 9
    Last Post: 03-16-2010, 03:34 PM

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