Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Accessing the cell address used in a function.

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Accessing the cell address used in a function.

    I've been looking for an answer to this, but I guess I don't know how to word my problem in the best way since I haven't been very successful.

    I have a cell that uses the MIN function to find the minimum value between two different cells. In another cell, I want to use the value from the chosen minimum cell in an equation. How do I access the address of that cell?

    I hope this makes sense.

    Thanks!

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,058
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Accessing the cell address used in a function.

    What is the equation that needs the address of the cell from which the min value is coming?
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #3
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Accessing the cell address used in a function.

    It's =MIN(F4*I6, E4*J6) and I want to access either F4 or E4 depending on which is gives the minimum value for the equation.

  4. #4
    Board Regular
    Join Date
    Mar 2018
    Location
    Japan
    Posts
    227
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Accessing the cell address used in a function.

    Why not just reference the cell with the MIN function in it for your new equation?
    Helper columns are the way of the future!

    All recommendations/work is completed in Excel 2013.
    ------
    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  5. #5
    Board Regular
    Join Date
    Mar 2018
    Location
    Japan
    Posts
    227
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Accessing the cell address used in a function.

    I just answered my own question. Please disregard my stupidity.

    What is the equation you are trying to put together?

    A simple IF statement came to mind based off of your above post,

    IF(F4
    Last edited by Robby19; May 7th, 2018 at 09:37 PM. Reason: Why are the code tags broken?
    Helper columns are the way of the future!

    All recommendations/work is completed in Excel 2013.
    ------
    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,058
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Accessing the cell address used in a function.

    Quote Originally Posted by honeysugaragave View Post
    It's =MIN(F4*I6, E4*J6) and I want to access either F4 or E4 depending on which is gives the minimum value for the equation.
    Suppose it's F4. What will you with the address of this cell?
    Assuming too much and qualifying too much are two faces of the same problem.

  7. #7
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Accessing the cell address used in a function.

    [QUOTE=Robby19;5064611]I just answered my own question. Please disregard my stupidity.

    What is the equation you are trying to put together?

    A simple IF statement came to mind based off of your above post,

    IF(F4


    Let's say F4*I6 is the smaller value. I want to access the value in F4 and multiply that by a different number.

  8. #8
    Board Regular
    Join Date
    Mar 2018
    Location
    Japan
    Posts
    227
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Accessing the cell address used in a function.

    Quote Originally Posted by honeysugaragave View Post
    Let's say F4*I6 is the smaller value. I want to access the value in F4 and multiply that by a different number.
    Code:
    =IF((F4*I6)<(E4*J6),F4*##,E4*##)
    Where ## is your different number.
    Helper columns are the way of the future!

    All recommendations/work is completed in Excel 2013.
    ------
    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  9. #9
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,058
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Accessing the cell address used in a function.

    Quote Originally Posted by honeysugaragave View Post
    it's =min(f4*i6, e4*j6) and i want to access either f4 or e4 depending on which is gives the minimum value for the equation.
    Quote Originally Posted by honeysugaragave View Post
    [...]
    let's say f4*i6 is the smaller value. I want to access the value in f4 and multiply that by a different number.
    =if(e4*j6 = min(f4*i6, e4*j6), e4, f4)*number
    Assuming too much and qualifying too much are two faces of the same problem.

  10. #10
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Accessing the cell address used in a function.

    Quote Originally Posted by Aladin Akyurek View Post
    =if(e4*j6 = min(f4*i6, e4*j6), e4, f4)*number

    Thank you to both of you!

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
  •