+ Reply to Thread
Results 1 to 15 of 15

Calculations based off formula from another cell

  1. 07-08-2014, 03:40 PM #1
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Calculations based off formula from another cell

    I'm pretty sure this belongs in programming/VBA, but I thought I'd try my luck in here first. I'm trying to do two things:

    1. I'm trying to show the formula of specific cells in the work sheet. So far I've only found out how to show formulas on the entire worksheet. I imagine there has to be some way of me doing this without using macros.

    2. Here's the doozy. What I'm trying to do is use the base code for a formula that is stored in one cell (Formula Page: B5:B7) and apply it to other cells (Calc Page: C4:C6). In other words, I want to apply the cell formula from B5:B7 to the cells C4:C6 and use them to calculate the TOTAL COST. I want it so that whenever I manipulate cells B5:B7, they are also appropriately manipulated in C4:C6.

    Please see attached for reference.

    Thanks for any help any of you can give me! Attachment 330773
    Attached Files Attached Files
    Last edited by Blackhawks; 07-08-2014 at 10:29 PM.
    Reply With QuoteRegister To Reply
  2. 07-08-2014, 03:45 PM #2
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    Ultimately, what I'm trying to do, is make changing formulas easier and making my check work easier. I have a 400k+ cell file, complete with TONS of different formulas. it's impossible to check each cell to make sure my formulas are correct.
    Reply With QuoteRegister To Reply
  3. 07-08-2014, 03:49 PM #3
    Speshul
    Speshul is offline
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Calculations based off formula from another cell

    You can create Named Ranges to use for formulas to make them easier to type in and work with
    To do this, go to the Formulas tab in Excel 2010, Name Manager
    New, name: Bat, Refers To: =1.37

    On Calc Page, enter the formula =B6*Bat in cell C6.

    Hope I understood the question and that helps, I've been bad at reading lately
    Last edited by Speshul; 07-08-2014 at 03:53 PM.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.
    Reply With QuoteRegister To Reply
  4. 07-08-2014, 03:52 PM #4
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Calculations based off formula from another cell

    I may over simplified this because I'm not sure why you are doing what you are doing (not that I have too!!! )...but this works for changing the total when you change that tax rate....like I said, if I over-simplified this, sorry
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  5. 07-08-2014, 04:08 PM #5
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    Thank you both for your suggestions, but that's not exactly what I'm looking for... at least I don't think. I might be able to use Name changer, but I have so many variables (bats,cats,prics,etc) and I have to use rather complex formulas... so I don't think that will work.
    Reply With QuoteRegister To Reply
  6. 07-08-2014, 10:00 PM #6
    Saarang84
    Saarang84 is offline
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Calculations based off formula from another cell

    Quote Originally Posted by Blackhawks View Post
    Thank you both for your suggestions, but that's not exactly what I'm looking for... at least I don't think. I might be able to use Name changer, but I have so many variables (bats,cats,prics,etc) and I have to use rather complex formulas... so I don't think that will work.
    Hi,

    Can you post a sample workbook which is equivalent to the real formulas that you use? Probably, we can get to understand your need better...
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang
    Reply With QuoteRegister To Reply
  7. 07-08-2014, 10:25 PM #7
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    This is just one of the main formulas I use. In case I wasn't clear the first time... whenever I change the formula in "Formula Page - B3:C4", I want the formulas in "Calc Page - B2:C4" to change as well. I hope this made sense. Let me know if you have any questions and again, thanks to anyone who can help me out!
    Reply With QuoteRegister To Reply
  8. 07-08-2014, 10:26 PM #8
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    I figured it out.. I replaced the file. Just download the attached file from the original post.
    Last edited by Blackhawks; 07-08-2014 at 10:30 PM.
    Reply With QuoteRegister To Reply
  9. 07-08-2014, 10:37 PM #9
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Calculations based off formula from another cell

    My 1st question would have to be - why the need to keep changing the formulas?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  10. 07-09-2014, 07:29 AM #10
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    Because at my work, the formulas are constantly changing, because each time I update this particular report, I receive data with inconsistent formatting - so I have to constantly change the formula... It's not difficult to do, but when you have 80k+ with over 100 columns of data points... it can get rather tedious.
    Reply With QuoteRegister To Reply
  11. 07-09-2014, 09:49 AM #11
    hoyasaxa215
    hoyasaxa215 is offline
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Calculations based off formula from another cell

    Why can't the cells in the "calc page" worksheet just reference the cells/formulas on the "formula page" worksheet? Is that what you're essentially attempting to accomplish?
    Reply With QuoteRegister To Reply
  12. 07-09-2014, 10:39 AM #12
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    yes, but it's not that easy as I stated above.
    Reply With QuoteRegister To Reply
  13. 07-09-2014, 11:15 AM #13
    hoyasaxa215
    hoyasaxa215 is offline
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Calculations based off formula from another cell

    What changes in the formulas? The actual function (e.g., "=vlookup"), the cell references (e.g., "$A$2:$C$4"), or both?
    Reply With QuoteRegister To Reply
  14. 07-09-2014, 11:19 AM #14
    Blackhawks
    Blackhawks is offline
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Calculations based off formula from another cell

    Sometimes one, sometimes both. usually both though
    Reply With QuoteRegister To Reply
  15. 07-09-2014, 11:38 AM #15
    hoyasaxa215
    hoyasaxa215 is offline
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Calculations based off formula from another cell

    I don't think I can't offer any help without seeing the file or something to get a better sense of what you're trying to accomplish. You may want to look into the "=replace" or "=indirect" functions.
    '
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stop previously calculated columns from updating based on new formula calculations
    By Northbaymac64 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2013, 06:40 PM
  2. [SOLVED] Conditionally formatting a cell based on formulas that contain percentage calculations
    By Titchy Dean in forum Excel General
    Replies: 4
    Last Post: 05-01-2012, 03:44 PM
  3. Refresh the cell formula calculations using VB
    By vtech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2010, 10:57 AM
  4. Calculations Based on Cell Format
    By assyrian47 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2007, 03:13 PM
  5. Calculations based on adjacent cell values
    By Jack in forum Excel General
    Replies: 4
    Last Post: 06-10-2006, 09:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1