Results 1 to 3 of 3

Thread: Complicate Excel question?

  1. #1
    Junior Member
    Join Date
    Jul 2012
    Posts
    2
    Rep Power
    0

    Complicate Excel question?

    Hey!

    I tried an IF Function, the problem is, I need to use too many functions, and it exceeds the limit.

    So my question is, if I need X numbers of something, to make 1 numbers of something else, but X can constantly change, from a Drop-down list, and so can "something else", how do I do that?

    For example:

    a b c d e
    1
    2 1
    3 2 1
    4 3 2 1
    5 4 3 2 1

    I need 2*a to make 1*b, or I need 4*a, to make 1*c.
    From the drop down list, I would choose "Make 1*d (d is chosen from list (which can be a,b,c,d,e)), using ?*a (a is chosen from list(which can be a,b,c,d,e))", since I want to know how many of a, or how many of b I need to make a c.

    I hope I made this clear enough, if not, let me know and I'll explain further.

    Thanks in advance!

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi Wilhelm Sorban,

    Welcome to ExcelFox !!!

    Could you post a sample workbook along with the expected result ?
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Jul 2012
    Posts
    2
    Rep Power
    0
    Hey,

    Thanks for replying!

    So I have this workbook, and I want to create a calculator, using the variables in the "Work" sheet, and using the data from "Temp" sheet.

    This site has the calculator I want to make, but it's in Java.
    Diablo 3 Gem Calculator

    Maybe if you take a look, it will explain better what I need.
    Attached Files Attached Files

Similar Threads

  1. hard question
    By mahmoud-lee in forum Excel Help
    Replies: 1
    Last Post: 05-28-2013, 02:27 PM
  2. Question on UDF LookUpConcat
    By K2` in forum Excel Help
    Replies: 4
    Last Post: 05-07-2013, 10:25 PM
  3. Workbook Event running VBA question
    By jamilm in forum Excel Help
    Replies: 4
    Last Post: 12-29-2012, 12:12 AM
  4. Question
    By lokvan in forum Excel Help
    Replies: 1
    Last Post: 12-04-2012, 08:49 AM

Posting Permissions

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