Help with Formula (Remove Round & Min)

[JoeRooney]

Hi,

I have a problem which i hope can be easily resolved ,

I have the below formula

=ROUNDDOWN(MIN(K2*Q2,I2*L2),2)

I want to remove the rundown and min from this formula , basically i only need (K2*Q2,I2*L2) , however excel rejects this.

is it possible to only use this portion of this formula.

Thanks

 

[Fluff]

That doesn't make much sense, (K2*Q2,I2*L2) returns two values, so which do you want?

 

[Gerald Higgins]

Your original formula basically says -
Which is the lowest value of these two values
K2*Q2
I2*L2
and then whichever is the lowest, return that value, rounded down.

So what do you actually want to do ?

 

[Joe4]

That doesn't make much sense, (K2*Q2,I2*L2) returns two values, so which do you want?

Doesn't the MIN function surrounding that take care of that (returns the minimum of those two values)?

 

[Fluff]

Doesn't the MIN function surrounding that take care of that (returns the minimum of those two values)?

Yes but the OP wants to remove the min function.

 

[JoeRooney]

That doesn't make much sense, (K2*Q2,I2*L2) returns two values, so which do you want?

Your right , please disregard this request , apologises

 

[Fluff]

Ok

 

[Joe4]

Yes but the OP wants to remove the min function.

Totally missed that! Shows you how well I read on a Friday morning!
I will just crawl back to my cave now...

 

[Gerald Higgins]

Morning ?!?!? It's 4 o'clock in the afternoon !!!!

 

[Fluff]

Probably just need some more