What is the equation that needs the address of the cell from which the min value is coming?
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!
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.
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.
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
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
[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.
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
Like this thread? Share it with others