Thanks:  0
Likes:  0

1. ## 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. ## 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?

3. ## 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. ## 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?

5. ## Re: Accessing the cell address used in a function.

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

6. ## Re: Accessing the cell address used in a function.

Originally Posted by honeysugaragave
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?

7. ## Re: Accessing the cell address used in a function.

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. ## Re: Accessing the cell address used in a function.

Originally Posted by honeysugaragave
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.

9. ## Re: Accessing the cell address used in a function.

Originally Posted by honeysugaragave
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.
Originally Posted by honeysugaragave
[...]
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

10. ## Re: Accessing the cell address used in a function.

=if(e4*j6 = min(f4*i6, e4*j6), e4, f4)*number

Thank you to both of you!