Help with nested IF with text data

[Executioner]

I'm having an issue getting the correct format for a nested IF statement.

In Cell C are text values such as:
EDD2059308
18676
N1878
EDD2067899
15678
12487
N0899

In H2, I have the following nested IF statement:
=IF(LEFT(C2,3)="EDD",1,0,IF(LEFT(C2,1)="N",3,0))))

If it's EDD it should return a value of 1
If it's a number it should return a value of 0
If its N it should return a value of 3

The error I get "you've entered too many arguments for this function"

I'm using excel 2003.

 

[njimack]

Excel Workbook
	A	B
1	EDD2059308	1
2	18676	0
3	N1878	3
4	EDD2067899	1
5	15678	0
6	12487	0
7	N0899	3
Sheet1

 

[Executioner]

=IF(LEFT(C2,3)="EDD",1,IF(LEFT(C2)="N",3,0))

Thanks. Works great. So it looks like I was close but my value for determining false should have been at the end?

 

[njimack]

Yep.

=IF(Test,Value_if_True,IF(Test,Value_if_True,Value_if_False))