Maybe a sample implementation of Dave's suggestion
(slightly adapted) would help illustrate that
it should work fine:

http://cjoint.com/?erfsK7SzLs
robotfighter_misc.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---