Anyone know how

[xptdriver]

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 buggered if I can...

[iamcool]

XPT,

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

Hope it is what you want.

http://forums.ozmium.com.au/images/icons/icon6.gif

[xptdriver]

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

[Wunfluova]

Another way to skin this cat would be :-

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

Wun