Mike,

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

Rob

"Mike" wrote in message
...
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i have what am i doing wrong

Please help