Imbeded IF Statements

[bradjedis]

Please help!

The condition is as follows:

Col A has a number
Col B has a number
Col C is to show the results as follows:

IF A > B, then C is to show a W
IF A < B, then C is to show a L
IF A = B, then C is to show a T

Thanks to all in advance,

B

[Mark W.]

On 2002-05-16 13:46, bradjedis wrote:
Please help!

The condition is as follows:

Col A has a number
Col B has a number
Col C is to show the results as follows:

IF A > B, then C is to show a W
IF A < B, then C is to show a L
IF A = B, then C is to show a T

Thanks to all in advance,

B

=VLOOKUP(A2-B2,{-9.99999999999999E+307,"L";0,"T";1E-307,"W"},2)

[ This Message was edited by: Mark W. on 2002-05-16 14:15 ]

[Brian]

In cell C2 place the formula =IF($A2>$B2,"W",IF($A2<$B2,"L",IF($A2=$B2,"T","ERROR")))

You can then fill or darag this down column C.

The structure is : If (this is true, then do this, else do this)

To examine how to write the equation. Place the couros at various places in the equation and click the equals sign button to the immediate left of the editing window. This will pring up the insert function dialog which will show you how the function is created and have links to help.

[bradjedis]

Thanks to all for the quick reply.

I will need to dig in on the second reply to understand it better. It looks interesting. The third reply did the trick.

Thanks again, B