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

XPT,

Had a play with excel for you - here is what you asked for.

Hope it is what you want.

Attached Files

xpt = IF.xls (13.5 KB, 436 views)

Gday iamcool

thanks alot for that.. that gave me what i wanted and also an idea of how to write my own IF formulae... thanks again

__________________
Good luck and good punting

xptdriver@hotmail.com

Another way to skin this cat would be :-

=IF(H2>5,0,120-H2*20)

Wun