How to apply a formula or VBA to get a specific result in a row

[maxrhino]

Hi,

I have a excel spreadsheet that includes some dual numbers through a column like

2-1

6-4

8-0 . . . and goes

<tbody>
</tbody>

My question is that how can I apply to get a specific result in next column. For example, if D3 2-1, then put a 1 into E3... Or if D3 2-2 (if two numbers are equal) put a T into E3... to make it simplier: If first number is bigger than the second one, put a Y into the next column, or second number is bigger than first one, then put a H... etc.... I need to apply the formula through all column, and have to point it again that, two numbers are in the same row, must not be separated, they are separated with a minus key.

Thanks for helps in advance.

 

[dulitul]

Try this

=IF(D3=2-1, E3=1, IF(D3=2-2, E3="T", IF(D3=2-3, E3="H", "")))

 

[Jeffrey20]

If the numbers are one-digit numbers then use:

=IF(LEFT(A1;1)>RIGHT(A1;1);"Y";IF(LEFT(A1;1)<right(a1;1);"h";if(left(a1;1)=right(a1;1);"t")))


If you don't know how many digits the numbers have use:

</right(a1;1);"h";if(left(a1;1)=right(a1;1);"t")))
=IF(LEFT(A9;FIND("-";A9)-1)>RIGHT(A9;LEN(A9)-FIND("-";A9));"Y";IF(LEFT(A9;FIND("-";A9)-1)<RIGHT(A9;LEN(A9)-FIND("-";A9));"H";IF(LEFT(A9;FIND("-";A9)-1)=RIGHT(A9;LEN(A9)-FIND("-";A9));"T")))

 

[Jeffrey20]

For some weird reason the forum cuts my formulas :S

Here they are in an image:

http://bayimg.com/aaLkiAAem

 

[maxrhino]

Thank you so much dulitul and Jeffrey20 for quick answers, however both formulas did not work, in fact I got error.

 

[maxrhino]

Image isn't displayed, Jef.

For some weird reason the forum cuts my formulas :S

Here they are in an image:

 

[Jeffrey20]

Yeah sorry, I thought BayImg accepted hotlinking, here it is

 

[maxrhino]

Thank you so much for all answers but Excel returns data value errors in any case.

 

[maxrhino]

Okay I managed to put the formula in a right way. Thank you so much Jeffrey, works like a charm and you made my day for this.