Formula needed ( conditional If statement)

[ATester]

Hi. I would like to create a calculated column which looks at the values in one column and returns the values in another column based on a formula.

So, for example if the value in cell a<0 then return "Excellent" , if the value is cell a >0 but less than 5 then return "Good", if the value in cell a is >5 then return "poor".

=if([ColumnName]<0,0);([ColumnName]>1,1) ;([ColumnName]>5,3); ([ColumnName]>10,4)

 

[scottsen]

= IF ([ColumnA] = "A" && [ColumnB] = 2013, "Y", "N")

 

[ATester]

= IF ([ColumnA] = "A" && [ColumnB] = 2013, "Y", "N")

Thanks