If statement or another formula help

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

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(a1>a2,"in the money","out of
the money"))

You can nest up to nine times.

-Brad
 
scott said:
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?
Click to expand...

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

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

Regards,
 
Back
Top