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

 

[GlennUK]

Like this:

=IF(ISBLANK(J3),"",MIN(J3,--L3))

 

[mars91]

Thank you very much!! =)

 

[mars91]

Hi again,

So srry.. I also trying to blank for N3 if J3

In N3 =IF(L3=M3,"YES","NO") , i tried to modify but not sure how.


Thank you

 

[GlennUK]

Like this:

=IF(ISBLANK(J3),"",IF(L3=M3,"YES","NO"))

 

[mars91]

Thanks for your help!!