hollow_man,

You left out an "End If"


I = 1
SUM = 0

WHILE (I < 11)
AI = "A" & I
IF (RS(AI) = "1") THEN
SUM = SUM + 10
ELSE
IF (RS(AI) = "2") THEN
SUM = SUM + 5
ELSE
SUM = SUM + 2.5
END IF
END IF '<< You left this out
I = I + 1
WEND

Enjoy
Simon Templer