Many If, Or statements in one formula

Hi,

I have a spreadsheet which I need to write a formula which looks at a field and if the number in the field starts with either 55, 50 or 78 it populates my selected field.

This is an example of what I am trying to do :

Please Login or Register  to view this content.

I appreciate any help to get this formula working.

Thanks

Try:

=IF(OR(Left(B22,2)={"55","52","78"}),"DEBIT ACCOUNT","")