22nd July 2005, 05:12 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Port Macquarie
Posts: 1,694
|
|
Anyone know how
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...
|