Comparison:What is the formula to do this?

**Jaymond Flurrie** · 10-10-2006, 10:33 AM

This is probably as easy as it gets, but how do I do this:

I have three columns, A, B and C
The formula I am asking should fill C based on A and B

A and B gets info from external source, it doesn't matter from where
C is "W" if A > B
C is "T" if A = B
C is "L" if A < B

so for example
A = 3, B = 4, C = L
A = 4, B = 4, C = T
A = 5, B = 4, C = W

What is the formula to do this?

edit. A little extension to this:
There is also column D
If C = W, D = 2
If C = T, D = 1
If C = L, D = 0

Should be even easier.

And please, answer for either English or Finnish version.