Accessing the cell address used in a function.

[honeysugaragave]

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!

 

[Aladin Akyurek]

What is the equation that needs the address of the cell from which the min value is coming?

 

[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.

 

[Robby19]

Why not just reference the cell with the MIN function in it for your new equation?

 

[Robby19]

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<E4,F4,E4)

 

[Aladin Akyurek]

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?

 

[honeysugaragave]

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<e4,f4,e4)[ quote]



Let's say F4*I6 is the smaller value. I want to access the value in F4 and multiply that by a different number. </e4,f4,e4)[>

 

[Robby19]

<e4,f4,e4)[ quote]
Let's say F4*I6 is the smaller value. I want to access the value in F4 and multiply that by a different number.</e4,f4,e4)[>

=IF((F4*I6)<(E4*J6),F4*##,E4*##)

Where ## is your different number.

 

[Aladin Akyurek]

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.

[...]<e4,f4,e4)[ quote]

let's say f4*i6 is the smaller value. I want to access the value in f4 and multiply that by a different number. </e4,f4,e4)[>

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

 

[honeysugaragave]

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

Thank you to both of you!