=IF(E9="H"


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 16:43:01 -0700, catefaulkes
wrote:

I wish to create a logical test - an IF statement that tests whether a cell
contains H, M or L, and output the result as a number.
I cannot get the IF statement to recognise text as true or false - my Excel
2007 gives an error when I try to do something like IF(E9=H ....) is there a
way to do this?