Hi Adam:
Try this
=IF(LEFT(A1)="E",50,IF(LEFT(A1,3)="SPX",100,IF(LEF T(A1,2)="SP",250,"what to
do elsewise?")))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"
m wrote in message
...
I have a column that has cells containing text. These cells could be in
three different formats. If they start with E, I want to output 50. If
they
start with SP, I want to output 250. If they start with SPX, I want to
output 100. Any suggestions would be much appreciated.

Thanks

Adam