View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 14
Default If statement or another formula help

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