To convert a number in excel to another number... being specific I would like to do the following :

if h2 = 1 then I would like to convert that to 100
if h2 = 2 then I would like to convert that to 80
if h2 = 3 then I would like to convert that to 60
if h2 = 4 then I would like to convert that to 40
if h2 = 5 then I would like to convert that to 20
if h2 is greater than 5 I would like to convert that to 0

I am sure there is a way to do it but I am ************ed if I can...

__________________
Good luck and good punting

xptdriver@hotmail.com