Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula If statement. | Excel Worksheet Functions | |||
if statement in formula | Excel Discussion (Misc queries) | |||
use value not formula in IF statement | Excel Worksheet Functions | |||
Can I use IF statement with a formula? | Excel Worksheet Functions | |||
if statement formula | Excel Discussion (Misc queries) |