Need Help to construct an axcel formula

[mars91]

Hi all,
I do not wish to do this in macro. How can i construct excel formula??

A is from row 3 to row 2500


Compare cell (A,10) value with cell (A,12) value.

Then after compare take the lower value and put in cell (A,13).
If cell (A,12) value = cell (A,13) value , Then cell (A,14)= Yes
If cell (A,12) value not = cell (A,13) Value , Then cell (A,14) = No

Please help..
Thanks in advance

 

[Yahya]

try this formula
in cell A14

=IF(A12=A13,"Yes","No")

but u said u have range from A3:A2500
how you would to construct this formula

 

[GlennUK]

In M3 use this formula:
=MIN(J3,L3)

in N3 use this formula:
=IF(L3=M3,"Yes","No")

and copy down.

 

[mars91]

Hi,
Thank you both for helping me..

I have a problem with this:

Within the column L cells already have vlookup formula.
So when i use =MIN(J3,L3) In M3.
This formula cannot work.

How can i get the min value from value of J3 with a value that was generated by vlookup formula of L3??

Thanks in advance

 

[GlennUK]

Then explain this:

Compare cell (A,10) value with cell (A,12) value

Then after compare take the lower value and put in cell (A,13).

... my formula does exactly what you asked for. If you require some other calculation, then describe it.

 

[mars91]

Hi,

Srry,i did tried, there is no wrong with the formula you gave, just that i face a problem..

yes i had tried, your formula does what i want if both (A,10) and (A,12) are in values.

But the problem now is, (A,12) have a vlookup formula in it. There is value in (A,12) but it is generated by the vlookup formula.

Thus when i use you formula, it is not able to get the min value out of (A,10) and (A,12).

So want to know, how can i get a min value out of (A,10) and (A,12) which is a value generate from vlookup??

 

[GlennUK]

It doesn't matter if the numbers are values or the results of vlookups. It will still work. Why do you think that it would not work?

 

[mars91]

I see, I was because i tried but it have problem.

L3 = 0.24 and it is a result of vlookup.
J3 = 0.6

By right , using In M3 this formula: =MIN(J3,L3)
M3 should be 0.24 but is appear as 0.6
Thus i am think is this a problem cause by the result of vlookup value

 

[GlennUK]

I'd say that the problem is probably caused by having text in your lookup table instead of values. You should never have values stored as text.

You can coerce text values to numeric by using the double-unary operator:
=MIN(J3,--L3)

 

[mars91]

Okay, thank you. That really help.

Srry, i have 1 last question to ask.
If J3 is blank ,then how can i blank the m3 also?


Thank you