You were nearly there - try this:

=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,59,0) )))

Hope this helps.

I'd better go to bed now, otherwise Bob will tell me off <g

Pete

Mike wrote:
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the value of 149
E3=3.00 then return the value of 99
E3=5.00 then return the value of 59