I would like a formula to say:

if A1 = A2 then "at the money", if a1 a2 then "in the
money", if a1 < a2 then "out of the money".

So far I have used the "if" function and came up with
=if(a1=a2,"at the money","in the money")

The function seems to allow me to make a logical statement
and then return an answer if it's true, and another answer
if it's false. But how to add a third possibility?

Thanks

By Nesting another IF:

=if(a1=a2,"at the money",IF(a1a2,"in the money","out of
the money"))

You can nest up to nine times.

-Brad
-----Original Message-----
I would like a formula to say:

if A1 = A2 then "at the money", if a1 a2 then "in the
money", if a1 < a2 then "out of the money".

So far I have used the "if" function and came up with
=if(a1=a2,"at the money","in the money")

The function seems to allow me to make a logical
statement
and then return an answer if it's true, and another
answer
if it's false. But how to add a third possibility?

Thanks
.

scott wrote:

I would like a formula to say:

if A1 = A2 then "at the money", if a1 a2 then "in the
money", if a1 < a2 then "out of the money".

So far I have used the "if" function and came up with
=if(a1=a2,"at the money","in the money")

The function seems to allow me to make a logical statement
and then return an answer if it's true, and another answer
if it's false. But how to add a third possibility?

By nesting, you can nest 8 (?) if conditions.

=IF(A1=A2,"at the money",IF(A1A2,"in the money","out of the money"))

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.