Try the following formula (which assumes your range of cells you want checked
is A6:A13.

=IF(COUNT(A6:A13)=0,"N",IF(AND(COUNT(A6:A13)=1,CO UNT(A6:A13)<=3),"I",IF(COUNT(A6:A13)=4,"S","Other" )))

Hope this helps.

Bill Horton

"Vick" wrote:

Excel 2003 I need to create a formula that would count each cell with a
number in it as 1 and assign a letter
if cells adds up to 0 = N
if cells adds up 1-3 = I
if cells adds up to 4 = S