it works, thank you very much ,is there any limit to the length of the formula i can put in one cell,what i'am trying to do is put a speed rating program which is written in basic into excel and that requires distances from 1000 to 2000 metres which would have to written the way you have shown me.I have bought a couple of books on excel but none seem to have examples of this kind of forumla can you recommend any ?
Any how thanks again for the help