Try this:

=IF(OR(B2<1,B210),"",A2+INDIRECT("$P$"&(B2+1)))

Hope this helps.

Pete

unouwanme wrote:
Thanks for all of your help/comments.

Basically all i am wanting to do is:
If the number in this cell is 1 add this to this, if 2 add this to this etc

=If(B2=1,A2+$P$2,if(b2=2,a2+$P$3,if(b2=3,a2+$P$4,i f(b2=4,a2+$P$5,if(b2=5,a2+$P$6,if(b2=6,a2+$P$7,if( b2=7,a2+$P$8,if(b2=8,a2+$P$9,if(b2=9,a2+$P$10,if(b 2=10,a2+$P$11,""))))))))))

Again thank ou for your replies