+ Reply to Thread
Results 1 to 5 of 5

Can Excel output a formula using a range of values for multiple variables?

  1. #1
    Registered User
    Join Date
    07-31-2008
    Location
    tx
    Posts
    7

    Can Excel output a formula using a range of values for multiple variables?

    Thanks for the help in the previous post guys, this forum has been a big help so far. Im just getting into excel here and was wondering if this was even possible.

    With my previous formula there are 3 variables, and within all my calculations I will ever perfrom with this formula the 3 variables will always have a range of values between "X=1-50", "Y=1-49", "Z=1-48".

    so thats 50*49*48= alot of calculations to solve (117600), Is there anyway to have excel output multiple solutions to my formula, with all the variables being between those ranges? (Im having a hard time wording this correctly, I hope it comes off right)

    Im not looking for a hundred thousand rows of information in reality, but if theres a way to cutdown on the amount of actual typing/pasting whatever, I would love to know.

    Thanks for any help -GK

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    I don't understand your objective. Can you post a workbook and explain in context?

  3. #3
    Registered User
    Join Date
    07-31-2008
    Location
    tx
    Posts
    7
    Im such an excel newbie, ill try to explain my thinking here and if it still comes out a garbled mess, ill come back once I have a better understanding of excel.

    Say my formula was X+1=Z

    X being the variable, Z being the result, and I wanted to find the solution if the variable "X" was

    X=1 (Example A)
    X=2 (Example B)
    X=3 (Example C)
    X=4 (Example D)
    X=5 (Example E)
    .
    .
    .
    X=35... all the way to 50.

    is there a way to have excel output the solutions individually to examples "A" through "E" without having to go to each cell and type in x=1 then x=2 then x=3 etc.

    Thanks again - GK

  4. #4
    Registered User
    Join Date
    07-31-2008
    Location
    tx
    Posts
    7
    wow, just wow. Im trying to make things as complicated as possible here and look like a real donkey in the process, let me phrase my question again, this time sans idiotic psychobabble

    I wanted excel to autofill cells with the numbers 1 through 50 in squential order, but seeing as im looking at a tutorial on how to do that right now, im just gonna stop typing and hope this post fades into obscurity.

    Ill keep the basic questions to myself untill ive put some time into learning excel

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Don't be too hard on yourself. We all started somewhere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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