Thanks for your help i have done it now,
k1ngy

"k1ngy" wrote:

Thanks for replies,
I have 23 alternatives! will the below still work they are
1=150,2=100,3=80,4=70,5=60,6=50,7=40,8=30,9=20,10= 10,11=0,12=0,13=0,14=0,15=0,16=0,17=0,18=0,19=0,20 =0,21=0,22=0,DNF=0
Thanks,

"Ron Coderre" wrote:

This structure works if there will only be a few alternatives:
=IF(A1=1,150,IF(A1=2,100,"not 1 or 2"))

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"k1ngy" wrote in message
...
I am trying to add more than one IF and cannot for love nor money,
One sheet called positions where i enter details of positions placed. i
will
enter 1 in a cell i want it to be 150 in another, if i enter 2 i want it
to
be 100 etc
Hope you can help,
k1ngy